How I can create a function-based index ?

From: Patrice Leclerc <patricel_at_mobilis.qc.ca>
Date: Tue, 21 Sep 1999 21:59:26 -0400
Message-ID: <7s9dbh$j9c$1@news.quebectel.com>

When I execute this statement:

SQL> CREATE INDEX idx ON emp (upper(ename)); CREATE INDEX idx ON emp (upper(ename))

                              *

ERROR at line 1:
ORA-00907: missing right parenthesis

Why this error?

thanks for your reply

Patrice Leclerc
patricel_at_mobilis.qc.ca Received on Tue Sep 21 1999 - 20:59:26 CDT