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

5 votes58 views1 answer
Copy table from one database to another mysql
SQL
0 vote147 views1 answer
Run docker container with database as rds metabase
SQL
0 vote111 views1 answer
Mariadb cast to int
SQL
0 vote110 views1 answer
Mysql sql.gz
SQL
0 vote112 views1 answer
Mysql grant grant option
SQL
0 vote119 views2 answers
Enter into postgresql database,create user and grant Access
SQL
5 votes117 views1 answer
AND OR NOT operators sql
SQL
0 vote115 views1 answer
Setval postgres example table id
SQL
4 votes116 views1 answer
Id increment ms sql server
SQL
2 votes153 views1 answer
Get the mysql table columns data type mysql
SQL