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
15815 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

Why having clause is used in sql?

978

How do I find duplicates in the same column?

1087

What is normalisation in sql?

1057

How many developers work on postgresql?

983

how do you know if your mysql server is alive? : Sql dba

1078

What is difference between stored procedure and trigger?

1168

How do you identify a primary key?

1063

Can we use pl sql in mysql?

1013

Explain table and field in sql?

1062

What is null in pl/sql?

1071

Is nosql faster than sql?

1023

Why stored procedure is faster than query?

1062

Can you call pl/sql package functions from within a fast formula?

1041

How to start the command-line sql*plus?

1054

Can we rollback truncate?

998