1 Reply Latest reply: Nov 29, 2012 4:38 PM by JustinCave RSS

    updating the data from one schema to another schema

    969952
      Hi All,

      I have schema called SCOTT. In this I have a table Called EMP. The structure of EMP is as follows.
      Create table EMP
      (
      ENO   Number,
      ID      Varchar2(20),
      PAN    VARCHAr2(20),
      name  varchar2(20),
      location  varchar2(20),
      zip    number (8),
      mailid   number(8),
      Apartment varchar2(20),
      roomno    number(8),
      corierid  number(8),
      corier_person_name  varchar2(30),
      Status  varchar2(1)
      );
      i have a view EPM_VW in some other schema SYS which is created on 5 tables having related data to EMP table. Now my requirement is if am doing any modifications like INSERT/Update/Delete or any thing on EMP table in SCOTT it should be effectting immediately on the VIEW. Can you please give me your ideas?

      Thanks.