| < Day Day Up > |
|
set wrap off linesize 132 pages 80; column key format a10; column pos format 990; column col format a10; column cons format a20; column tab format a20; column own format a10; select decode(t.constraint_type,'P','Primary','R','Foreign' ,'U','Alternate','Unknown') "Key" ,t.table_name "Tab", t.constraint_name "Cons" ,c.column_name "Col", c.position "Pos" from user_constraints t, user_cons_columns c where t.constraint_type in ('P','R','U') and t.table_name = c.table_name and t.constraint_name = c.constraint_name order by t.table_name, t.constraint_type, c.position;
| < Day Day Up > |
|