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 vote133 views1 answer
Sql server cannot create database diagram
SQL
0 vote183 views1 answer
Print hello world in plsql
SQL
0 vote141 views1 answer
Increase speed of like queries postgres
SQL
3 votes138 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote131 views1 answer
Sql delete row with auto increment
SQL
0 vote133 views1 answer
Sql server manager close connection
SQL
0 vote129 views1 answer
Find largest table in mysql database
SQL
1 vote137 views1 answer
Partition by sql server
SQL
0 vote140 views1 answer
Oracle create table auto generated primary key
SQL
4 votes167 views3 answers
Postgres drop all tables
SQL