Skip to content

Instantly share code, notes, and snippets.

@ecormaksin

ecormaksin/oracle_get_synonyms.sql

Created February 28, 2020 00:42
Show Gist options
  • Save ecormaksin/0ed6c03b86e752228e59f720353082e7 to your computer and use it in GitHub Desktop.
Save ecormaksin/0ed6c03b86e752228e59f720353082e7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oracle_get_synonyms.sql
SELECT
*
--'CREATE OR REPLACE SYNONYM ' || OWNER || '.' || SYNONYM_NAME || ' FOR ' || TABLE_OWNER || '.' || TABLE_NAME || ';' as create_or_replace_synonym
FROM ALL_SYNONYMS
WHERE
OWNER = '<スキーマ名>'
ORDER BY
SYNONYM_NAME
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment