/* FK 걸려있는지 확인 쿼리 */
SELECT *
FROM ALL_CONSTRAINTS
WHERE OWNER = 'SSYADM'
AND R_CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS
WHERE OWNER = 'SSYADM'
AND TABLE_NAME = 'TB_OM001'
)
SELECT *
FROM ALL_CONSTRAINTS
WHERE OWNER = 'SSYADM'
AND R_CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS
WHERE OWNER = 'SSYADM'
AND TABLE_NAME = 'TB_OM001'
)