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 vote115 views1 answer
Import in mysql without a software
SQL
0 vote158 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote155 views1 answer
Sqlite higher or equal
SQL
16 votes168 views1 answer
Mssql int max value
SQL
1 vote144 views1 answer
Sql only five first row
SQL
1 vote146 views1 answer
Cross schema query oracle 2 users
SQL
0 vote172 views1 answer
Download mysql database to excel in android studio
SQL
0 vote200 views1 answer
Sql declare variable single line
SQL
0 vote205 views1 answer
Sqlalchemy query return only n results
SQL
123 votes935 views5 answers
Sql where contains
SQL