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 vote267 views1 answer
Create new table from old table with data
SQL
0 vote267 views1 answer
Sql server query database space available
SQL
1 vote280 views1 answer
Sql select whole row max column
SQL
16 votes316 views1 answer
Mysql mediumint max value
SQL
0 vote278 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote266 views1 answer
Contact mysql column field
SQL
0 vote296 views1 answer
Mysql order by rand limit 1 really slow
SQL
1 vote267 views2 answers
Sql now - 1 day
SQL
0 vote253 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
-1 vote262 views1 answer
Mysql #1064 error
SQL