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

2 votes189 views1 answer
Mysql id of inserted row
SQL
3 votes230 views2 answers
Funktion LOWER/UPPER sql
SQL
-1 vote196 views1 answer
Mysql extract days
SQL
0 vote179 views1 answer
Match end of string regex sql
SQL
1 vote198 views1 answer
Get parameter value in mysql trigger
SQL
0 vote179 views1 answer
Postgresql heritage
SQL
0 vote202 views1 answer
Regex any word except sql
SQL
5 votes177 views2 answers
Sql server port number
SQL
0 vote195 views1 answer
Str_to_date sql server
SQL
0 vote140 views1 answer
Check if due date is less than todays date sql
SQL