Skip to content

Instantly share code, notes, and snippets.

@ggdio
Last active December 23, 2015 07:09
Show Gist options
  • Save ggdio/6599130 to your computer and use it in GitHub Desktop.
Save ggdio/6599130 to your computer and use it in GitHub Desktop.
--ORACLE
SELECT
*
FROM
ALL_CONSTRAINTS
WHERE
R_OWNER = 'NOME_OWNER'
AND R_CONSTRAINT_NAME IN
(SELECT
CONSTRAINT_NAME
FROM
ALL_CONSTRAINTS
WHERE
TABLE_NAME = 'NOME_TABELA')
ORDER BY TABLE_NAME;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment