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 vote185 views1 answer
Get id if is not equal in certain table
SQL
8 votes294 views2 answers
Oracle auto increment primary key
SQL
0 vote173 views1 answer
What is between keyword used for
SQL
0 vote400 views1 answer
Sql datum formatieren
SQL
0 vote176 views1 answer
Drop all triggers oracle
SQL
1 vote192 views3 answers
Mysql on delete set null
SQL
0 vote203 views1 answer
What is common table expression in sql
SQL
0 vote183 views1 answer
SQL: calculate hours from two dates
SQL
0 vote182 views1 answer
Create database like
SQL
0 vote177 views1 answer
Custom row number
SQL