Skip to content

Instantly share code, notes, and snippets.

@martindsouza
Last active January 15, 2021 17:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save martindsouza/04433a5cc4302e81721bc4d18cddaade to your computer and use it in GitHub Desktop.
Save martindsouza/04433a5cc4302e81721bc4d18cddaade to your computer and use it in GitHub Desktop.
-- 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
/
Microsoft Office UserMicrosoft Office Usergit/martindsouza/gist/04433a5cc
Microsoft Office User Microsoft Office User
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment