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

3 votes294 views4 answers
Mysql create table from select statement
SQL
0 vote311 views1 answer
Oracle step procedure
SQL
6 votes291 views1 answer
Allsource oracle
SQL
0 vote294 views1 answer
Sql string length postgresql
SQL
0 vote293 views2 answers
Php convert dbf to mysql
SQL
2 votes283 views1 answer
Plsql left() function
SQL
0 vote310 views1 answer
Postgresql find missing id
SQL
0 vote266 views1 answer
Plsql trigger insert update
SQL
9 votes304 views4 answers
Last mysql
SQL
1 vote252 views1 answer
Prevent duplicate rows in postgres
SQL