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

3 votes137 views2 answers
Mysql add 2 hours
SQL
0 vote151 views1 answer
Setval postgres example table id
SQL
0 vote150 views1 answer
Mysql date time string format for marshmellow field schema
SQL
0 vote143 views1 answer
Sql last 7 days
SQL
0 vote166 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
1 vote154 views1 answer
Mysql select from outside
SQL
0 vote227 views1 answer
Mssql unique key accept nulls
SQL
0 vote146 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
2 votes142 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote100 views1 answer
How to set field to null in sql
SQL