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 votes349 views2 answers
Mysql 1 day ago
SQL
0 vote322 views1 answer
Mysql set boolean default value
SQL
0 vote324 views1 answer
How to change the field size of an existing column
SQL
0 vote329 views1 answer
Insert into select with group by
SQL
6 votes317 views1 answer
Postgresql get year
SQL
10 votes350 views4 answers
Primary key in sql
SQL
1 vote343 views1 answer
Partition by sql server
SQL
8 votes349 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote352 views1 answer
Connecting mySQL to STS
SQL
0 vote312 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL