synonym oracle

Solutions on MaxInterview for synonym oracle by the best coders in the world

showing results for - "synonym oracle"
Michela
11 Mar 2017
1-- Can be a table, package, procedure...
2CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_table;      
3CREATE OR REPLACE PUBLIC SYNONYM syn_name FOR my_schema.my_table;
4
5-- Through a dblink:
6CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_table@my_dblink;
7
8SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'synonym_name';
Aicha
13 Jun 2018
1CREATE OR REPLACE PUBLIC SYNONYM suppliers FOR app.suppliers;