Create synonyms for dropped tables : Synonym « User Previliege « Oracle PL / SQL






  1. Oracle PL / SQL
  2. User Previliege
  3. Synonym

Create synonyms for dropped tables

 
SQL>
SQL>
SQL> SELECT 'CREATE PUBLIC SYNONYM ' || table_name
  2         || ' for ' || user || '.' || table_name || ';'
  3  FROM DBA_TABLES
  4  WHERE dropped = 'NO';

no rows selected

SQL>








Related examples in the same category

1.Create synonym for table
2.Creating a Public Synonym
3.Creating a Private Synonym
4.drop synonym addresses;
5.drop public synonym;
6.create synonym for a view
7.Viewing synonyms and what they reference.