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 votes161 views4 answers
Sqlite drop table
SQL
0 vote155 views1 answer
Sql view index
SQL
0 vote155 views1 answer
Update using case in mysql
SQL
3 votes167 views4 answers
Ubuntu stop mysql
SQL
0 vote169 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
2 votes158 views2 answers
Mysql on duplicate key ignore
SQL
0 vote165 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote254 views1 answer
ORA-00942
SQL
1 vote164 views1 answer
Join first name and last name sql
SQL
0 vote173 views1 answer
Increase speed of like queries postgres
SQL