Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 15813 Views
- Fidelity, KCP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is varchar sql?
How to display the records between two range in Oracle SQL Plus?
How does join work in sql?
Explain architecture of sql server notification services?
What is sql used for?
How insert into statements in sql?
What is thread join () in threading?
What is difference between sql function and stored procedure?
Why left join is used in sql?
What are the benefits of pl/sql packages?
What is the plv (pl/vision) package offers?
How does index help in query performance?
What is an intersect?
Does execute immediate commit?
What are the commands used in sql?
