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 vote193 views1 answer
Check index sql server
SQL
2 votes207 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote451 views1 answer
Power bi connect to postgresql
SQL
17 votes269 views2 answers
How to assign date field for table in mysql
SQL
3 votes203 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
3 votes200 views2 answers
Postgres show table schema
SQL
3 votes211 views1 answer
Stpop start psql server
SQL
1 vote193 views1 answer
Python escape mysql
SQL
0 vote260 views1 answer
Oracle swap partition
SQL
0 vote186 views1 answer
How to execute stored output to csv files
SQL