Re: generate index ddl
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 4 Sep 2003 18:13:36 -0700
Message-ID: <2687bb95.0309041713.1adf70e1_at_posting.google.com>
Date: 4 Sep 2003 18:13:36 -0700
Message-ID: <2687bb95.0309041713.1adf70e1_at_posting.google.com>
gnuoytr_at_rcn.com (robert) wrote in message news:<da3c2186.0309041303.7fa5b96e_at_posting.google.com>...
> i've seen the various threads, and looked at the
> *_index views and the tables in sys. what i don't see,
> and i use Advanced Query Tool (which shows it), is the
> ordering of columns in an index.
>
> is there an "obvious" location for this??
>
> thanks,
> robert
Try looking again: DBA_IND_COLUMNS.COLUMN_POSITION
HTH -- Mark D Powell -- Received on Fri Sep 05 2003 - 03:13:36 CEST