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 votes329 views2 answers
How to run postgresql in linux
SQL
0 vote347 views3 answers
How to assign custom id in mysql
SQL
0 vote327 views4 answers
What is unique key in sql
SQL
0 vote337 views1 answer
Oracle table privileges
SQL
0 vote308 views1 answer
Set column width in sqlplus
SQL
0 vote360 views1 answer
Mysql backup query
SQL
0 vote308 views1 answer
Min salary in sql
SQL
0 vote363 views1 answer
Oracle winter time change
SQL
3 votes330 views1 answer
Mysql insert on dupèlicate
SQL
1 vote301 views1 answer
How to select random rows from table
SQL