Re: can I do this in SQL??

Tom Kyte's solution is a jewel, John Birch's variant for the user_ tables is great too - if you want all the indexes on all the tables you can change the WHERE clause to:

where a.table_name = b.table_name
and a.index_name = b.index_name
group by substr(a.index_name,1,30), a.uniqueness ;

You might then want to add table_name to your select (and group by clause) as well. I'm adding all three versions to my "bag of tricks".

In article <7umovi$t98$1_at_diana.bcn.ttd.net>,   "Jorge" <pumuky22_at_usa.net> wrote:
> Hi everyone, I'm trying to do this select ....
> I have two tables (user_indexes and user_ind_columns) and I want this
> output:
>
> index1 column1 column2 column3
> by row
>
> thanks
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 23 1999 - 07:16:34 CDT