Oracle Sql Tutorial#79 How to create/drop synonym in Oracle Database
In this tutorial we are going to see how to create synonym and how to drop
Assignment Link: will be available soon
create table emp as select * from employee;
CREATE [OR REPLACE] [PUBLIC] SYNONYM [schema .] synonym_name
FOR [schema .] object_name;
CREATE OR REPLACE PUBLIC SYNONYM emp1
FOR hr.emp;
CREATE OR REPLACE SYNONYM scott.emp2
FOR hr.emp;
Object can be :
table
view
sequence
stored procedure
function
package
materialized view
java class schema object
user-defined object
synonym
DROP [PUBLIC] SYNONYM [schema .] synonym_name [force];
DROP PUBLIC SYNONYM emp1;
Oracle SQL Complete Tutorial/Training/Course for the beginner:
• Tutorial#1 Basics Of Oracle SQL for B...
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-3193...
Contacts Email:
[email protected]
Instagram:
/ equalconnect
Twitter:
/ lrnwthr
#equalConnectCoach #rakeshmalviya #OracleTutorial