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

6 votes201 views2 answers
Sql sequence
SQL
0 vote220 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
1 vote255 views1 answer
Postgres select as csv
SQL
28 votes196 views4 answers
Mysql delete database
SQL
0 vote215 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
11 votes195 views2 answers
MySQL DISTINCT
SQL
0 vote262 views2 answers
How to take recent row without limit in mysql
SQL
0 vote197 views1 answer
Const pool = mysql.createpool()
SQL
2 votes183 views1 answer
Scaffold npgsql net core
SQL
0 vote269 views1 answer
How to add auto increment primary key
SQL