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 vote136 views1 answer
Sql search all columns of database oracle sql
SQL
1 vote171 views1 answer
Psql client write to bash variable
SQL
0 vote173 views1 answer
Drop a view in sqlite
SQL
1 vote151 views1 answer
Oracle extract minute from date
SQL
11 votes130 views6 answers
Distinct sql
SQL
0 vote204 views4 answers
Stored procedure sql
SQL
0 vote131 views1 answer
Starting mysql shell lampp ubuntu
SQL
3 votes150 views2 answers
Enter mysql command line
SQL
9 votes124 views4 answers
Add primary key to existing table sql
SQL
0 vote146 views1 answer
How to insert same table data using mysql query
SQL