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 vote300 views2 answers
Mssql show database size
SQL
2 votes294 views1 answer
Oracle find unusable indexes
SQL
3 votes299 views1 answer
Force using index oracle
SQL
0 vote315 views1 answer
Java nosql sort
SQL
10 votes324 views2 answers
SQL rounding numbers
SQL
50 votes377 views6 answers
Sql duplicate rows
SQL
0 vote330 views1 answer
Mysql reset wp_options
SQL
6 votes306 views3 answers
Mysql change auto_increment start value
SQL
2 votes300 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote327 views1 answer
Add created and updatedAt fields in mysql
SQL