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 vote355 views1 answer
Rename table column name in mysql
SQL
0 vote303 views1 answer
Mysql find foreign key references
SQL
0 vote346 views3 answers
Insert query in ci
SQL
0 vote361 views1 answer
Mysql add text to existing field
SQL
0 vote368 views1 answer
Postgresql linux password
SQL
0 vote335 views3 answers
Convert sql query to python pandas
SQL
1 vote364 views1 answer
Postgres check blocking
SQL
-1 vote340 views2 answers
Get day in sql
SQL
1 vote320 views1 answer
Mysqli connect
SQL
0 vote339 views4 answers
Sql limit 1 offset 1
SQL