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 vote199 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
1 vote206 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote231 views1 answer
Oracle to_number
SQL
0 vote215 views2 answers
Mysql row_number() example
SQL
0 vote199 views1 answer
Select only one row sql
SQL
0 vote270 views1 answer
Dynamic where clause in sql server stored procedure
SQL
10 votes198 views5 answers
Create table mysql query
SQL
0 vote191 views1 answer
Mysql Error Code: 1005
SQL
5 votes247 views1 answer
Dbms_metadata.get_ddl table
SQL
14 votes1.3K views1 answer
Sql value of string
SQL