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

3 votes326 views1 answer
Sql server check version
SQL
0 vote355 views1 answer
Trigger stock phpmyadmin
SQL
0 vote323 views1 answer
Mysql show create db
SQL
6 votes281 views2 answers
Generate c# class from sql server table
SQL
0 vote366 views2 answers
Execute stored procedure without db set
SQL
1 vote317 views1 answer
Neo4j display all nodes and relationships
SQL
2 votes340 views4 answers
List databases in sql server
SQL
-1 vote347 views5 answers
Operator in sql
SQL
0 vote346 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote342 views1 answer
Radius search with point data in mysql
SQL