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 vote142 views1 answer
Java sql timestamp now
SQL
1 vote127 views1 answer
Table infromation in sql server
SQL
5 votes188 views1 answer
Mysql created at yesterdau
SQL
0 vote101 views1 answer
Finish transaction sql
SQL
6 votes149 views3 answers
Mysql create database utf8
SQL
1 vote130 views1 answer
Create table tablename as select * from tablename
SQL
0 vote141 views1 answer
Sql server select ignore dupplicates
SQL
0 vote100 views1 answer
Select all domains of database firbird
SQL
0 vote147 views3 answers
Fetlife
SQL
1 vote141 views1 answer
Psql lst trigger
SQL