Last active
January 15, 2021 17:31
-
-
Save martindsouza/04433a5cc4302e81721bc4d18cddaade to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Test | |
-- Another test | |
alias testmartin=select 1 | |
from dual | |
/ | |
alias fk=select f.constraint_name, f.r_owner || '.' || f.r_constraint_name reference_constraint | |
, t.table_name | |
from user_constraints f | |
, user_constraints t | |
where f.table_name = upper(:1) | |
and f.constraint_type = 'R' | |
and f.r_constraint_name = t.constraint_name | |
/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Microsoft Office User M i c r o s o f t O f f i c e U s e r g i t / m a r t i n d s o u z a / g i s t / 0 4 4 3 3 a 5 c c |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Microsoft Office User M i c r o s o f t O f f i c e U s e r |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment