ORACLE SQL 10G Pour les Nuls & Zéro

SQL> CREATE [OR REPLACE] [PUBLIC] SYNONYM NomSynonym FOR [schéma.]nomObjet [@lienBaseDonnées];

SQL> CREATE PUBLIC SYNONYM site FOR sales.industrie;
SQL> CREATE PUBLIC SYNONYM societe FOR sales.industrie;
SQL> CREATE PUBLIC SYNONYM agence FOR sales.industrie;

SQL> CREATE [OR REPLACE] SYNONYM [schéma.]NomSynonyme FOR [schéma.]nomObjet [@lienBaseDonnées];

SQL> CREATE SYNONYM sales.taux FOR sales.salaire;
SQL> CREATE SYNONYM sales.primes FOR sales.salaire;

SQL> DROP [PUBLIC] SYNONYM [schéma.]nomSynonyme [FORCE];

SQL> DROP PUBLIC SYNONYM site;
SQL> DROP PUBLIC SYNONYM societe;
SQL> DROP PUBLIC SYNONYM agence;
SQL> DROP SYNONYM sales.taux;
SQL> DROP SYNONYM sales.primes;

SQL> SELECT * FROM dba_synonyms WHERE owner <>'PUBLIC';