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:
youtube.com/watch?v=3v4s3XMw4q0&list=PLiLpm…


follow me on:
Facebook Page:
facebook.com/LrnWthr-319371861902642/?ref=bookm…

Contacts Email:
[email protected]

Instagram:
instagram.com/equalconnect/

Twitter:
twitter.com/LrnWthR

#equalConnectCoach #rakeshmalviya #OracleTutorial