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 vote126 views2 answers
Default constraint in ms sql
SQL
0 vote169 views1 answer
How to get table current identity value in sql server
SQL
0 vote139 views1 answer
Create a sql server database programmatically
SQL
0 vote127 views1 answer
Select only one row sql
SQL
3 votes133 views2 answers
Postgres show table schema
SQL
0 vote135 views1 answer
How to query all tables mysql at the same time
SQL
0 vote125 views1 answer
Restore backupfile discourse
SQL
0 vote138 views1 answer
Sql server synonym
SQL
6 votes123 views2 answers
Mysql concatenate two columns into one
SQL
1 vote212 views3 answers
Uninstall postgresql mac
SQL