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 vote185 views1 answer
Oracle undo usage per session
SQL
1 vote149 views1 answer
Ms sql how to see active job current run time
SQL
1 vote215 views1 answer
Mysql connect bash
SQL
0 vote229 views1 answer
Creating sqeuence in oracle database
SQL
0 vote191 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote240 views3 answers
Mysql keyword search
SQL
23 votes154 views3 answers
Mysqldump
SQL
0 vote197 views1 answer
How to join result table in mysql
SQL
0 vote200 views1 answer
Insert data from stored procedure into table
SQL
0 vote206 views1 answer
Sql query wordpress export post
SQL