Untitled
SELECT COUNT(*) FROM all_constraints WHERE constraint_type = 'R' AND constraint_name LIKE 'FKY_%' AND owner = 'RMS'; ===================================== SELECT COUNT(*) FROM all_constraints c WHERE constraint_type = 'R' AND constraint_name LIKE 'FKY_%' AND owner = 'RMS' AND EXISTS ( SELECT 1 FROM all_objects o WHERE o.owner = c.owner AND o.object_name = c.constraint_name ); ===================================== SELECT c.owner, c.constraint_name, c.table_name, c.r_constraint_name, c.constraint_type, c.status FROM all_constraints c WHERE c.constraint_type = 'R' AND c.constraint_name LIKE 'FKY_%' AND c.owner = 'RMS' ORDER BY c.constraint_name;
Leave a Comment