1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
SELECT cons_col1.table_name "table de référence"
, cons_col1.column_name "colonne de référence"
, cons_col2.table_name "table référencée"
, cons_col2.column_name "colonne clé étrangère"
FROM ALL_CONS_COLUMNS cons_col1
, ALL_CONS_COLUMNS cons_col2
, ALL_CONSTRAINTS cons1
, ALL_CONSTRAINTS cons2
WHERE cons_col1.table_name='EQUIPEMENT'
AND cons_col1.column_name='EQUIPEMENT_ID'
AND cons_col1.constraint_name = cons1.constraint_name
AND cons1.constraint_type = 'P'
AND cons2.r_constraint_name = cons1.constraint_name
AND cons2.constraint_name = cons_col2.constraint_name
ORDER BY cons_col2.table_name; |
Partager