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
15622 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 an alias command?

1007

Can we use two order by clause in query?

920

What is a sql schema used for?

1031

What is rtm stands for?

1024

Can you do multiple joins in sql?

977

What is sql*loader and what is it used for? : aql loader

1097

What is the difference between a query and a report?

904

Explain the the update statement in sql?

990

What are the parts of a sql statement?

1030

Why triggers are used?

939

What are the different tcl commands in sql?

1106

What are pl sql data types?

957

What is the difference between subquery and correlated query?

991

Is big data nosql?

888

What are analytical functions in sql?

972