Re: How to retrieve the Foreign key information in Oracle

kennypoon wrote:
> I use this SQL statement
> Select pka.table_name PK_Table_Name, pka.column_name PK_COLUMN_NAME,
> pkc.table_name FK_TABLE_NAME, pkc.column_name FK_COLUMN_NAME from
> user_cons_columns pka, user_constraints pkb, user_cons_columns pkc where
> pkc.constraint_name = pkb.constraint_name and pkb.constraint_type='R'
> and pka.constraint_name = pkb.r_constraint_name and pka.position =
> pkc.position and pka.table_name = 'ABC' order by pka.table_name,
> pka.column_name, pkc.table_name, pkc.column_name
>
> but the performance is too slow. Is any other statement which has much
> better performance?
>
> --
> Posted via http://dbforums.com

Yes: select * from emp;

-- 
Regards, Frank van Bortel