SELECT
A .CONSTRAINT_NAME ,
A .TABLE_NAME ,
B.CONSTRAINT_NAME
FROM
USER_CONSTRAINTS A,
USER_CONSTRAINTS B
WHERE
A .CONSTRAINT_TYPE = 'R'
AND B.CONSTRAINT_TYPE = 'P'
AND A .R_CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND A .CONSTRAINT_NAME = 'FK_T_ACCT_C_REFERENCE_T_LOAN'
P 代表主键
R 代表外键
