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

2 votes265 views1 answer
Date_format for time sql
SQL
0 vote302 views1 answer
Sql quary stuf
SQL
0 vote268 views1 answer
Mysql remove tabs from string
SQL
4 votes314 views1 answer
Postgres delete last row
SQL
-1 vote285 views3 answers
Compute age mysql
SQL
0 vote280 views1 answer
Sql datediff db2
SQL
0 vote270 views1 answer
Implizite joins sql
SQL
6 votes264 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
2 votes290 views1 answer
Sqlite3 show columns name
SQL
0 vote255 views1 answer
Provera dupliranih konatakata
SQL