Re: generate index ddl

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0309041713.1adf70e1_at_posting.google.com>...
> gnuoytr_at_rcn.com (robert) wrote in message news:<da3c2186.0309041303.7fa5b96e@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 --

turns out that AQT is not returning the numbers. sql*plus does.

<hangs head in shame>
robert Received on Fri Sep 05 2003 - 20:47:19 CEST