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 vote118 views2 answers
Add colum in sql
SQL
0 vote116 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
0 vote114 views1 answer
Sql grant select only
SQL
0 vote124 views1 answer
Remove transient options sql wordpress
SQL
1 vote256 views1 answer
Postgres upgrade to superuser
SQL
10 votes115 views2 answers
Sql pagination offset
SQL
6 votes109 views1 answer
SQL insert all columns
SQL
-1 vote72 views2 answers
Sql query examples
SQL
0 vote118 views1 answer
Mysql update table from select on another table
SQL
2 votes127 views1 answer
Postgresql create table as select
SQL