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 vote149 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote160 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote151 views1 answer
Create table database in psql
SQL
4 votes138 views1 answer
Oracle session date format
SQL
8 votes160 views1 answer
Script to add datafile to tablespace
SQL
1 vote145 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote202 views1 answer
Sql commands in android
SQL
0 vote148 views1 answer
Sql tabelle erstellen
SQL
0 vote141 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
17 votes177 views6 answers
Sql current date
SQL