Hi,
I want to use create a function based index with hibernate and oracle. (A function based index in oracle is an index which uses SQL functions like MAX, MIN, but DESC as well.)
I think about something like:
@Table(appliesTo ="TESTTABLE", indexes = { @Index(name="test_idx", columnNames = {"testColumn1 desc", "MAX(testColumn2)"}) })
which doesn't work this way! I don't want to do it with a kind of "after-scheme-creation" script, but directly from the hibernate annotations. Is it possible to create a table annotation with such an annotation?
|