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 vote151 views2 answers
Close external port 3306 with iptables
SQL
3 votes160 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote127 views2 answers
Influxdb delete measurement based on date
SQL
10 votes150 views3 answers
Sql check double value
SQL
5 votes158 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote172 views1 answer
Insert output identity
SQL
2 votes173 views1 answer
Create mysql user on all hosts
SQL
2 votes187 views1 answer
Orcale index size
SQL
14 votes146 views5 answers
Sql oracle limit
SQL
0 vote150 views1 answer
Hou to run job from cmd .exe sql server jop
SQL