Re: How to know if an index is ASC or DESC ?
From: Michel Cadot <micadot_at_netcourrier.com>
Date: Mon, 6 Aug 2001 13:36:59 +0200
Message-ID: <9klvgs$7ui$1_at_s1.read.news.oleane.net>
Date: Mon, 6 Aug 2001 13:36:59 +0200
Message-ID: <9klvgs$7ui$1_at_s1.read.news.oleane.net>
"toto" <anonyme_at_195.6.224.137> a écrit dans le message news: 9kls66$muk$1_at_news.x-echo.com...
> Hello,
>
> in oracle 8i, we can use table user_ind_columns and its column descend t
> o known if the index is ASC or DESC.
>
> But, i cannot find this information into my oracle 7 database ?
>
> Anyone know how to retrieve this information ?
>
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Article poste via Voila News - http://www.news.voila.fr
> Le : Mon Aug 6 12:40:06 2001 depuis l'IP : 195.6.224.137 [VIP 6647606]
IFAIK, in Oracle7 index are always created in ascending order even if the clause DESC is given at creation time. So there is no such information in the dictionary.
-- Have a nice day MichelReceived on Mon Aug 06 2001 - 13:36:59 CEST