Re: How I can create a function-based index ?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 22 Sep 1999 11:22:31 -0400
Message-ID: <C=ToNyTrSHBMibe5oeefFqvgTJRh@4ax.com>

A copy of this was sent to "Patrice Leclerc" <patricel_at_mobilis.qc.ca> (if that email address didn't require changing) On Tue, 21 Sep 1999 21:59:26 -0400, you wrote:

>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?

see the web site in my signature. I have a paper there that shows how to do this and what is needed (specifically you need Oracle8i, release 8.1 EE)

>
>thanks for your reply
>
>Patrice Leclerc
>patricel_at_mobilis.qc.ca
>
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Sep 22 1999 - 10:22:31 CDT