Re: Descending Indexes

From: Ritu <ritub_at_teri.res.in>
Date: Tue, 08 Feb 2000 04:33:06 GMT
Message-ID: <87o6a2$pol$1@nnrp1.deja.com>

In article <389EBE3E.4661_at_yahoo.com>,
connor_mcdonald_at_yahoo.com wrote:
> Ritu wrote:
> >
> > Hi
> > I have struggled so much but couldn't find a way to create desceding
> > indexes using Oracle8 and Delphi4. My problem is that I want to
display
> > dates in descending order and also at the same time give the
facility to
> > update them so cannot use queries and views don't allow order by
clause.
> >
> > Can anybody tell help me in solving the problem
> >
> > Ritu
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> descending index syntax is supported in all oracle versions...actual
> descending indexes are supported from 8i upwards.
>

Yes you are right. Infact, I was trying the following syntax for creating indexes

create index indaa on tblbb (col1, col2 desc)

but didn't work. As in Oracle8's documentation for Create Index,it is written that
" ASC and DESC mean asceding and Descending and are allowed for DB2 compatibility but have no effect."

You mean to say this syntax has effect in Oracle 8i?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 07 2000 - 22:33:06 CST