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

7 votes303 views1 answer
Sql disable safe mode
SQL
0 vote290 views2 answers
Insert into
SQL
1 vote334 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote297 views1 answer
Mysql how to reset primary key
SQL
0 vote321 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
8 votes315 views1 answer
My sql version
SQL
0 vote315 views2 answers
Mysql calcular idade
SQL
1 vote327 views1 answer
T-sql disable system versioning
SQL
7 votes292 views1 answer
Connect mysql docker
SQL
18 votes301 views6 answers
Creating table in MySQL
SQL