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

1 vote259 views1 answer
Oracle columns table
SQL
3 votes248 views2 answers
How to force truncate a table in mysql
SQL
8 votes190 views8 answers
Second highest salary in mysql
SQL
0 vote219 views1 answer
How to use lower case in mysql
SQL
0 vote224 views1 answer
Do postgresql
SQL
2 votes225 views1 answer
Mysql sysdate - 1 day
SQL
3 votes215 views1 answer
How to remove characters from string in mysql
SQL
0 vote219 views2 answers
Mysql regexp match word
SQL
2 votes226 views2 answers
How to view created temporary tables in mysql
SQL
2 votes227 views1 answer
How to create sql database
SQL