How can we Get the Updated Rows? ie, There is 100s of Rows i
updated the Rows who have salary 5000. then i want to select
the Updated Rows. How can we achieve it?
create table t1 as select * from emp where 1=2;
create or replace trigger t1
after update on emp
for eachrow
begin
insert into t1
values(empno,'ename',job,'hiredate',sal,comm,deptno);
end;
after create trigger
then u updated.
To Refer this Site to Your Friends 
Site Map
