1 Reply Latest reply: Apr 12, 2013 6:43 PM by Chandrakaanth Ramamurthy RSS

    how to insert some records in one table and some records in another table

    1001879
      Interview question

      how insert records in two tables by using trigger

      CREATE or REPLACE TRIGGER Emp_Ins_Upd_Del_Trig
      BEFORE delete or insert or update on EMP
      FOR EACH ROW
      BEGIN
      if UPDATING then
      UPDATE emp2
      SET
      empno = :new.empno,
      ename = :new.ename
      --, job = :new.job
      --, mgr = :new.mgr
      --, hiredate = :new.hiredate
      , sal = :new.sal
      --, comm = :new.comm
      --, deptno = :new.deptno;
      sdate = :new.sdate,
      edate = :new.edate
      end if;

      if INSERTING then
      INSERT INTO emp2
      VALUES
      ( :new.empno
      , :new.ename
      --, :new.job
      --, :new.mgr
      --, :new.hiredate
      , :new.sal
      --, :new.comm
      --, :new.deptno
      new.sdate,
      new.edate);
      end if;
      if DELETING then
      DELETE FROM emp2
      WHERE empno = emp2.empno;
      end if;
      END;
      /
      it is working fine but he wants to insert some specific litimit on one table and some specified limit of records in one ..
      In this senerio can i insert records by use count of records...

      please help me..