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 vote215 views1 answer
Select value from previous row in postgresql
SQL
26 votes186 views10 answers
Insert in to table sql
SQL
0 vote273 views1 answer
Select year from dual oracle
SQL
1 vote245 views1 answer
Spring postgresql reset auto increment to 0
SQL
2 votes226 views1 answer
Select from array in psql
SQL
4 votes235 views3 answers
Mysql update with join
SQL
0 vote240 views1 answer
How convert into in in sql query
SQL
0 vote238 views1 answer
ORACLE PARSE STRING
SQL
3 votes230 views2 answers
Funktion LOWER/UPPER sql
SQL
7 votes222 views1 answer
Grant schema permissions postgres
SQL