3,491
社区成员
发帖
与我相关
我的任务
分享
SELECT A.TABLE_NAME||'.'||A.COLUMN_NAME||'='||B.TABLE_NAME||'.'||B.COLUMN_NAME
FROM
(select A.CONSTRAINT_NAME,B.TABLE_NAME,B.COLUMN_NAME,A.R_CONSTRAINT_NAME
from dba_CONSTRAINTS A,DBA_CONS_COLUMNS B where constrainT_type='R' AND A.CONSTRAINT_NAME=B.CONSTRAINT_NAME
AND B.TABLE_NAME IN ('K1','K2','K3','K4','K5')) A,
(select distinct A.R_CONSTRAINT_NAME,B.TABLE_NAME,B.COLUMN_NAME
from dba_CONSTRAINTS A,DBA_CONS_COLUMNS B where constrainT_type='R' AND A.R_CONSTRAINT_NAME=B.CONSTRAINT_NAME
AND B.TABLE_NAME IN ('K1','K2','K3','K4','K5')) B
WHERE A.R_CONSTRAINT_NAME=B.R_CONSTRAINT_NAME;