Function based index

[bensmail]

I want to create a function based index but i can't cause:

ERREUR Line 1 :
ORA-00907: Missing right parenthese

SYNTAX:
CREATE INDEX idx3 ON emp (substr(emp.empno,1,4) between emp.mgr and emp.sal);

What's wrong??

[nagarjuna]

Try this...

CREATE INDEX idx3 ON emp (substr(emp.empno,1,4));

this solves the problem and completes the purpose of function based index....