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

0 vote314 views1 answer
Redshift running queries
SQL
1 vote249 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote263 views1 answer
Sql get number of days between two dates
SQL
0 vote248 views1 answer
Change schema of all tables postgres
SQL
0 vote247 views1 answer
Fill up postgres db
SQL
0 vote233 views1 answer
Sql random decimal
SQL
0 vote241 views1 answer
Oracle select invalid views
SQL
0 vote272 views1 answer
How to write if case in select query in select statement
SQL
0 vote255 views1 answer
How to output a different column name in mysql
SQL
0 vote274 views1 answer
Mssql unique key accept nulls
SQL