Dear DBA Gurus,
I have Table A and Table B whose structures are almost similar except Table
B has a date-time field column. Whenever I insert a new record into Table A
I want to insert the same record into the Table B along with the date-time
stamp at which the new record is inserted
Hi Gurus,
I got the solution. Here is the modified code:
create or replace trigger trig_dept1 after insert on dept for each row
begin
insert into dept1(deptno, dname, loc, date_time) values(:new.deptno,
:new.dname,
:new.loc, sysdate);
end;
Thanks Rob Fegan and Amol Joshi