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
Can we use having without group by in sql?
Is sql dba a good career? : SQL DBA
What are the commands used in sql?
Does sql full backup truncate logs?
What pl/sql package consists of?
Can we use threading in pl/sql?
Does sql require a server?
How long does it take to learn pl sql?
how to include character strings in sql statements? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is data control language?
what is the stuff function and how does it differ from the replace function? : Sql dba
what are the performance and scalability characteristics of mysql? : Sql dba
What does count (*) do in sql?
What is the main difference between sql and pl/sql?