Oracle SQL beginner tutorials With exercise/ Database Basic to Advance Training - 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: https://www.youtube.com/watch?v=3v4s3XMw4q0&list=PLiLpmqwkwkCt0QeXD8j7BwIoOaBGBRrZC follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR #equalConnectCoach #rakeshmalviya #OracleTutorial