Answers for "how to use oracle synonyms"

SQL
3

oracle synonym

-- Can be a table, package, procedure...
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_table;      
CREATE OR REPLACE PUBLIC SYNONYM syn_name FOR my_schema.my_table;

-- Through a dblink:
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_table@my_dblink;

SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'synonym_name';
Posted by: Guest on April-29-2021
0

synonym oracle

CREATE OR REPLACE PUBLIC SYNONYM suppliers FOR app.suppliers;
Posted by: Guest on March-10-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language