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 vote217 views2 answers
Psql commande \gset
SQL
0 vote223 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
2 votes203 views1 answer
Pandas to sql index
SQL
0 vote230 views1 answer
Asp.net core sql server stored procedure
SQL
36 votes271 views6 answers
Change column data type sql
SQL
0 vote225 views2 answers
Pop sql insert value into
SQL
4 votes210 views1 answer
Restart for pg_hba.conf file
SQL
5 votes201 views3 answers
Mysql update field from one table to another
SQL
0 vote197 views1 answer
How to to get current date and time in sql
SQL
6 votes228 views3 answers
Update with inner join postgres
SQL