Revision: 36177
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at November 19, 2010 02:37 by kamilch
Initial Code
select 'CREATE or REPLACE SYNONYM ' || :target_schema || '.' || object_name || ' for ' || :src_schema || '.' || object_name || ';' from ( select table_name as object_name from all_all_tables where owner = :src_schema union select sequence_name as object_name from all_sequences where sequence_owner = :src_schema );
Initial URL
Initial Description
Initial Title
Generate SYNONYMS SQL
Initial Tags
Initial Language
PL/SQL