Advanced Search

Generate SYNONYMS SQL

/ Published in: PL/SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT 'CREATE or REPLACE SYNONYM ' || :target_schema || '.' || object_name || ' for ' || :src_schema || '.' || object_name || ';' FROM (
  2. SELECT table_name AS object_name FROM all_all_tables WHERE owner = :src_schema
  3. UNION
  4. SELECT sequence_name AS object_name FROM all_sequences WHERE sequence_owner = :src_schema
  5. );

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.