Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How I can create a function-based index ?

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

From: EElliott <elliottel_at_my-deja.com>
Date: Wed, 22 Sep 1999 22:16:57 GMT
Message-ID: <7sbkgd$vsr$1@nnrp1.deja.com>


Function based Indexes are a new function for 8i. Other than that I don't know what to tell you!

I can't wait til we get 8i so we can create cas insensitive searches that will use an index. :)

In article <7s9dbh$j9c$1_at_news.quebectel.com>,   "Patrice Leclerc" <patricel_at_mobilis.qc.ca> 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?
>
> thanks for your reply
>
> Patrice Leclerc
> patricel_at_mobilis.qc.ca
>
>

--
Thanks for the help!

E. Elliott

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 22 1999 - 17:16:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US