Re: Index problem with Oracle 8.0.5

You do not create an index in assending or descending order. The order of the query is based on an ORDER BY clause. The order by clause can have the desc at the end of it.

Example

Secect my_col
FROM my_table
where my_col like 'super%'
order by my_col desc;

Marc Parkinson
Senior Oracle Engineer

"Ziegler thomas" <tz_at_operon.fr> wrote in message news:aok6nv$233$1_at_news2adm.tiscali.fr...
> Hi,
>
> Is it possible to create an index in Descending order in Oracle 8.0.5 ?
> I've tried to add the keyword DESC after the column name but it seems to
be
> ignored .
> Here is what I tried :
> CREATE INDEX Myindex ON MyTable (MyColumn DESC) ....
>
> Thanx,
> Thomas.
>
>
>
Received on Thu Oct 17 2002 - 21:21:28 CDT