Answers for "how to create a synonym for a view in oracle"

SQL
1

oracle create 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;
Posted by: Guest on April-29-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language