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

7 votes109 views3 answers
Select latest entry in sql table
SQL
1 vote93 views1 answer
What is int in mysql
SQL
0 vote75 views1 answer
Postgres create database if not exists
SQL
1 vote107 views1 answer
Oracle grant on all tables in schema
SQL
19 votes101 views5 answers
Date between in mysql
SQL
2 votes114 views3 answers
Current setting postgres timezone
SQL
0 vote105 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote106 views1 answer
Sql where part of string match
SQL
0 vote99 views1 answer
How to check if there is no database schema
SQL
0 vote106 views1 answer
A network or instance-specific error sql server
SQL