SELECT SUBSTRB(A.TABLE_NAME,1,25) TABLE_NAME,SUBSTRB(C.COLUMN_NAME,1,25) COLUMN_NAME,SUBSTRB(B.TABLE_NAME,1,25) REFER_TABLE
FROM USER_CONSTRAINTS A,USER_CONSTRAINTS B,USER_CONS_COLUMNS C
WHERE A.R_CONSTRAINT_NAME=B.CONSTRAINT_NAME
AND A.TABLE_NAME='BB'
AND A.CONSTRAINT_NAME=C.CONSTRAINT_NAME
/
FROM USER_CONSTRAINTS A,USER_CONSTRAINTS B,USER_CONS_COLUMNS C
WHERE A.R_CONSTRAINT_NAME=B.CONSTRAINT_NAME
AND A.TABLE_NAME='BB'
AND A.CONSTRAINT_NAME=C.CONSTRAINT_NAME
/
FROM USER_CONSTRAINTS A,USER_CONSTRAINTS B,USER_CONS_COLUMNS C
WHERE A.R_CONSTRAINT_NAME=B.CONSTRAINT_NAME
AND A.CONSTRAINT_NAME=C.CONSTRAINT_NAME