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 vote320 views1 answer
Drop check command
SQL
11 votes357 views1 answer
Get ddl materialized view oracle
SQL
0 vote357 views1 answer
Hour differeence in mysql
SQL
0 vote340 views1 answer
Hive batch drop table
SQL
0 vote372 views1 answer
Hour and minute between two datatime sql
SQL
2 votes338 views1 answer
Wait delay in sql server
SQL
-1 vote341 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote392 views1 answer
Pgadmin save data greyed out
SQL
1 vote340 views4 answers
Mysqldump 1 table only
SQL
0 vote349 views2 answers
Athena drop partition
SQL