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 a unique key and primary key and foreign key?
What is difference between stored procedures and application procedures?
What are the datatypes available in pl/sql ?
What is difference sql and mysql?
How does sql profiler work?
What is union and union all keyword in sql?
How many types of primary keys are there?
Is sql a backend?
what happens if you no create privilege in a database? : Sql dba
In pl/sql, what is bulk binding, and when/how would it help performance?
What is an exception in pl/sql?
How to start the command-line sql*plus?
Whis is not false in primary key?
What are the operators in sql?
Why partition by is used in sql?