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

1 vote97 views1 answer
Convert money to varchar sql server
SQL
0 vote130 views1 answer
Create table sql generator
SQL
5 votes219 views1 answer
Oracle asynchronous procedure
SQL
0 vote136 views1 answer
Sql select rows with different values in one column
SQL
0 vote124 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote133 views1 answer
Sql server express download
SQL
0 vote127 views1 answer
Mariadb number format
SQL
0 vote118 views3 answers
Sql count condition
SQL
0 vote132 views1 answer
Sum sqlserver
SQL
0 vote149 views1 answer
Sql server create constraint
SQL