Re: Three-Way table join

In article <4desmi$e5o_at_athos.cc.bellcore.com>, parris_at_walleye.esp.bellcore.com (Parris Geiser) writes:
|> Hi,
|> I would like to produce a report from the tables:
|> user_tab_columns
|> all_constraints
|> user_cons_columns
|> that looks like the following:
|> TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH CONSTRAINT_NAME CONSTRAINT_TYPE
|>
|> Does anyone know how to do a join to produce this?
|> Thanks,
|> parris

I think you can try this :

select a.table_name, a.column_name, a.data_type, a.data_length,

       b.constraint_name, b.constraint_type from user_tab_columns a, all_constraints b where a.table_name = b.table_name;

Hope it will help you ! Received on Tue Jan 16 1996 - 00:00:00 CET