Oracle Sql Tutorial#79 How to create/drop synonym in Oracle Database

Published: 08 December 2019
on channel: EqualConnect Coach

4,928

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

Watch video Oracle Sql Tutorial#79 How to create/drop synonym in Oracle Database online without registration, duration hours minute second in high quality. This video was added by user EqualConnect Coach 08 December 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,928 once and liked it 70 people.

45,348

2.7K