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?
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
what is difference between delete and truncate commands? : Sql dba
who introduced sql?
Why do we use procedures?
Why use triggers in sql?
How do you bind variables in pl sql?
Which is the correct statement about truncate and delete?
How many types of normalization are there?
Does sql view stored data?
What is implicit cursor in pl sql?
Why do you partition data?
how are mysql timestamps seen to a user? : Sql dba
How insert into statements in sql?
What is set transaction?
What is rownum and rowid?
Where do we use pl sql?