create table t1 as select * from emp where 1=2; create or replace trigge

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?

Question Posted / mahesh

4 Answers
15609 Views
Fidelity, KCP, I also Faced
E-Mail Answers

Answer Posted / mahesh

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.

Is This Answer Correct ?

5 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is primary key secondary key alternate key candidate key?

977

What does (*) mean in sql?

903

What is a sql select statement?

991

Why is sql*loader direct path so fast?

1052

What is mutating trigger?

965

What is a unique key?

997

What is the difference between cross join and natural join?

957

How to handle bulk data?

1266

What is an ndf file?

925

what is rollback? : Sql dba

1019

what is the difference between where clause and having clause? : Sql dba

947

Why do we need a foreign key?

1013

what is myisam? : Sql dba

999

Mention what are different methods to trace the pl/sql code?

1096

Can we use ddl statements in stored procedure?

1094