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
- 15815 Views
- Fidelity, KCP, I also Faced
- E-Mail Answers
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
Why having clause is used in sql?
How do I find duplicates in the same column?
What is normalisation in sql?
How many developers work on postgresql?
how do you know if your mysql server is alive? : Sql dba
What is difference between stored procedure and trigger?
How do you identify a primary key?
Can we use pl sql in mysql?
Explain table and field in sql?
What is null in pl/sql?
Is nosql faster than sql?
Why stored procedure is faster than query?
Can you call pl/sql package functions from within a fast formula?
How to start the command-line sql*plus?
Can we rollback truncate?
