For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Friends
Could anyone help me out creating this function based index?
CREATE INDEX DB_FLUX ON LTB(TO_DATE(TO_CHAR(DATABASE,'DD/MM/YYYY'))) TABLESPACE INDX;
Error on line 1:
ORA-01743:only pure functions can be indexed
Tks a lot