yeah...
you can create index desceding index in ORACLE
for example
CREATE INDEX index_name
ON table_name( column_name DESC)
...........
i don't know whether it help you....hmh.
--
(Y). .(Y)
%(> <)%
Ritu <ritub_at_teri.res.in>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
news:87ljf5$sn1$1_at_nnrp1.deja.com¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> 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.
Received on Mon Feb 07 2000 - 02:51:37 CST