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

2 votes171 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote158 views1 answer
Copying query result to excel
SQL
0 vote146 views1 answer
Flask sqlalchemy update row
SQL
0 vote115 views1 answer
Procedures and functions in pl/sql
SQL
2 votes147 views1 answer
Mysql how to store lat,lng
SQL
0 vote176 views1 answer
Sql alter table order by
SQL
0 vote157 views1 answer
Delete data from database sqlite android
SQL
0 vote148 views1 answer
Json not contains mysql
SQL
23 votes190 views2 answers
Query to delete a database in mysql
SQL
6 votes143 views4 answers
Eloquent to sql with bindings
SQL