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 vote135 views1 answer
Alter check command
SQL
0 vote122 views1 answer
Drop all tables db2
SQL
0 vote116 views1 answer
Pgadmin see indexes
SQL
1 vote134 views2 answers
Mysql between
SQL
0 vote126 views1 answer
Mysql select smaller of two values
SQL
0 vote122 views1 answer
Mysql where in keep order
SQL
1 vote125 views2 answers
Change table name phpmyadmin
SQL
0 vote145 views3 answers
Constraint sql
SQL
6 votes207 views1 answer
Sql insert values into table
SQL
0 vote114 views1 answer
Selecting Data in SQL - Select Data
SQL