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

1 vote199 views3 answers
Remove unique key from a table
SQL
13 votes206 views5 answers
Sql default
SQL
39 votes295 views4 answers
Select duplicates in sql
SQL
0 vote201 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
5 votes205 views2 answers
Oracle find all tables with column name
SQL
0 vote189 views1 answer
Sql server split string and insert into table select
SQL
1 vote227 views1 answer
Sql order by timestamp
SQL
1 vote185 views1 answer
Importance of comment in mysql
SQL
0 vote197 views1 answer
Show the colums of table sql
SQL
0 vote209 views1 answer
How to move a column to different spot mysql
SQL