Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query all_synonyms

SQL> SQL> SELECT owner, synonym_name   2  FROM all_synonyms   3  WHERE table_owner = 'SYS' AND table_name = 'ALL_TABLES'; PUBLIC     ALL_TABLES 1 row selected. SQL>