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?

Answers were Sorted based on User's Feedback



How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000...

Answer / srinivas

first create new table with the same structure if table_name1
then create a trigger as follws

create or replace trigger <trigger_name>
after update on <table_name1>
for each row
begin
insert into <new_table_name>
values(:new.<column_name1>,:new.<column_nam2>...... );
end;

then update table_name1 table
after that check it new table

Is This Answer Correct ?    4 Yes 0 No

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000...

Answer / 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

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000...

Answer / sandeeptiwari1111@gmail.com

We can achieve this w/o using any Trigger also.
For this result you just need to put your update statement inside this below block


begin
----Your udate statement
dbms_output.put_line(sql%rowcount);
end;

Is This Answer Correct ?    1 Yes 3 No

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000...

Answer / sudipta santra

create table t1 as select * from emp;
truncate table t1;

create or replace trigger tri_t1
before update on emp
for eachrow
begin
insert into t1
values(old.empno,old.ename,old.job,old.hiredate,old.sal,
old.comm,old.deptno);

end;
after create trigger
then if u update then the old updated values will be kept
in t1 table.

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

Which is better stored procedure or query?

0 Answers  


I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,


What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,


How do you sort in sql?

0 Answers  


How can I speed up sql query?

0 Answers  






What does joining a thread mean?

0 Answers  


What does the file extension accdb stand for?

0 Answers  


what is self join and how it works??

2 Answers   Infosys,


What is the mutating table and constraining table?

0 Answers  


What is sql scripting?

0 Answers  


what is cross join? : Sql dba

0 Answers  


Is pl sql still used?

0 Answers  


Categories