Re: SQL: want to create index based on part of column value

This will only work in 8i. see technet.oracle.com

Jean-Pierre Dery wrote:

> Hi,
>
> how can I specify an index that indexes only the first 10 characters of a
> column values ?
>
> Something like "create index myindex on mytable(substr(mycolumn, 1, 10));" ?
> Seems logical but it doesn't work.
>
> Any ideas ?
>
> Thx
>
> Jean-Pierre Dery
Received on Wed Jun 02 1999 - 00:23:22 CDT