在Oracle中,您可以使用以下SQL語(yǔ)句來(lái)查看外鍵關(guān)聯(lián)的表:
SELECT
a.table_name AS foreign_key_table,
a.constraint_name AS foreign_key_name,
a.column_name AS foreign_key_column,
b.table_name AS referenced_table,
b.column_name AS referenced_column
FROM
all_cons_columns a
JOIN
all_constraints c ON a.constraint_name = c.constraint_name
JOIN
all_cons_columns b ON c.r_constraint_name = b.constraint_name
WHERE
c.constraint_type = 'R'
ORDER BY
a.table_name, a.constraint_name, a.column_name;
此查詢將返回外鍵表、外鍵名稱、外鍵列、參考表和參考列等信息。您可以根據(jù)需要調(diào)整查詢中的條件和列,以滿足您的具體需求。