Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Descending Indexes

Re: Descending Indexes

From: ÀÌÈÆ <hoon_at_web.dwe.co.kr>
Date: Mon, 7 Feb 2000 17:51:37 +0900
Message-ID: <87m0vf$a6$1@news2.kornet.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US