Synonym oracle

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';

Synonym oracle

CREATE OR REPLACE PUBLIC SYNONYM suppliers FOR app.suppliers;

Similar codes

0 vote356 views1 answer
Convert polygon to text in mysql
SQL
0 vote334 views1 answer
How to get all values in a table mysql in c#
SQL
2 votes363 views1 answer
How to create sql database
SQL
0 vote382 views1 answer
T-sql update table variale
SQL
0 vote386 views1 answer
How to map sql column to custom names
SQL
50 votes433 views6 answers
Install mysql on ubuntu
SQL
0 vote362 views1 answer
Oracle create job if not exists
SQL
0 vote334 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote385 views1 answer
C# execute transact sql
SQL
0 vote350 views1 answer
Big table in mysql
SQL