Juick
Discuss
Discover
Login
pc
10 years ago
extract
parus
synonyms
Oracle
select 'create public synonym ' || synonym_name ||
' for ' || table_owner || '.' || table_name || ';'
from dba_synonyms
where owner = 'PUBLIC'
and table_owner = 'PARUS'
/
Recommend
Replies (0)