System Tables Data Dictionary Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. System Tables Data Dictionary
  4. 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>