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 vote204 views4 answers
Postgresql between month
SQL
-1 vote249 views1 answer
Search all sql tables for a value
SQL
1 vote202 views1 answer
OstgreSQL version
SQL
14 votes217 views1 answer
Oracle alter table add column not null
SQL
0 vote156 views1 answer
Get all stored procedures in sql server
SQL
1 vote303 views1 answer
Oracle see column type
SQL
0 vote211 views1 answer
Drop all procedures sql server
SQL
4 votes206 views1 answer
Data types in sql
SQL
4 votes311 views2 answers
Convert utc to est sql
SQL
21 votes248 views3 answers
Sql server search column name in all tables
SQL