Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: function based index
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