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
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 |
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 |
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 |
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 |
How do I run pl sql in sql developer?
Temporary table vs Table variable in sql server?
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
What is exception? What are the types of exceptions?
How to create your own reports in sql developer?
explain normalization concept? : Sql dba
What is autocommit sql?
What are the types of triggers ?
26 Answers Aspire, BirlaSoft, TCS,
Is sql an operating system?
What is a parameter query?
What is a sql statement?
What are two statement types in sql?