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: function based index

Re: function based index

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Fri, 13 Dec 2002 13:43:40 +0100
Message-ID: <uvjlga1qr60o62@corp.supernews.com>


Just don't understand why you ask. If you have 8.0.5 at your disposal you can easily find out for yourself that it won't work. Also a very basic Google search would have returned many hits presenting phrases like 'function based indexes where introduced in Oracle 8i'.

regards,
Peter

"Christoph Seidel" <chris666.seidel_at_gmx.de> schreef in bericht news:atcgk3$11vmin$1_at_ID-143718.news.dfncis.de...
> since i have no 8.1 here, only 8.0.5, is this possible:?
>
> create index idx on table(substr(field, 1, 1));
>
> and then use the select:
>
> select * from table where substr(field, 1, 1) = 'X';
>
>
>
Received on Fri Dec 13 2002 - 06:43:40 CST

Original text of this message

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