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 vote153 views1 answer
Mysql server not running
SQL
8 votes149 views1 answer
Sql remove leading spaces
SQL
12 votes156 views6 answers
Between in sql
SQL
0 vote145 views1 answer
Sql quary intervewi question
SQL
3 votes147 views1 answer
Ms sql skip take
SQL
0 vote162 views1 answer
Allow null in psql
SQL
1 vote165 views2 answers
Create a unqie constraint mysql
SQL
0 vote153 views1 answer
Load data from text file to mysql database on mac terminal
SQL
16 votes174 views6 answers
Python sqlite
SQL
2 votes135 views2 answers
Function in sql
SQL