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 will u find statistics of a database objects?
What is string join?
Does a primary key have to be a number?
I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
What are the basic sql commands?
What is mutating sql table?
How to add new employee details in an employee_details table with the following details
What is procedure explain with example?
What is blind sql injection?
can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?
What is dense_rank in sql?
How to combine two stored procedures in sql?