Synonym oracle

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 vote127 views1 answer
Mysql exception output
SQL
0 vote133 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
4 votes106 views1 answer
Data types in sql
SQL
0 vote112 views2 answers
Sql max count
SQL
1 vote120 views1 answer
Find size of all DB's postgres
SQL
0 vote114 views1 answer
Mysql command line ubuntu
SQL
0 vote112 views1 answer
Call function sql oracle
SQL
0 vote117 views1 answer
Sql anywhere create procedure
SQL
1 vote97 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
2 votes117 views2 answers
Set database timezone mysql
SQL