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 vote302 views1 answer
Delete double on SQL with multiple primary keys
SQL
1 vote325 views1 answer
Regular expression in sql server
SQL
0 vote303 views1 answer
Get who is hired in january in sql
SQL
5 votes320 views1 answer
Sort order on two columns sql
SQL
1 vote308 views3 answers
Psql fatal database does not exist
SQL
51 votes679 views6 answers
Installing mysql on ubuntu
SQL
1 vote304 views2 answers
DROP TABLes regardless of constraints
SQL
1 vote322 views1 answer
Sql not equal multiple columns
SQL
0 vote310 views1 answer
C# check if mysql query modified rows
SQL
0 vote310 views1 answer
Add column to table with default value plsql
SQL