Untitled

 avatar
unknown
plain_text
a month ago
720 B
5
Indexable
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