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

How do I run pl sql in sql developer?

0 Answers  


Temporary table vs Table variable in sql server?

0 Answers   Wipro,


Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,


What is exception? What are the types of exceptions?

0 Answers  


How to create your own reports in sql developer?

0 Answers  






explain normalization concept? : Sql dba

0 Answers  


What is autocommit sql?

0 Answers  


What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,


Is sql an operating system?

0 Answers  


What is a parameter query?

0 Answers  


What is a sql statement?

0 Answers  


What are two statement types in sql?

0 Answers  


Categories