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 vote187 views1 answer
Mysql create table like
SQL
2 votes210 views1 answer
Sql percentage with % rounded down
SQL
2 votes180 views1 answer
Rails execute sql
SQL
0 vote209 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
19 votes192 views3 answers
How to change column type psql
SQL
1 vote196 views1 answer
Show structure of table in sql
SQL
1 vote193 views1 answer
Pl sql insert into table
SQL
0 vote190 views1 answer
Oracle service name view
SQL
24 votes199 views5 answers
Import dump mysql
SQL
0 vote182 views1 answer
Heavy table in mysql
SQL