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 vote157 views1 answer
Sql where part of string match
SQL
0 vote166 views1 answer
Sql update subtract value
SQL
1 vote174 views3 answers
Connection string mysql
SQL
0 vote153 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote124 views1 answer
Postgresql add leading zeros
SQL
7 votes156 views3 answers
Postgre describe table
SQL
1 vote181 views1 answer
Key validation sql
SQL
0 vote146 views1 answer
Equi joins in oracle
SQL
0 vote171 views1 answer
Mysql error 1251
SQL
0 vote154 views2 answers
Create row number in sql
SQL