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
- 15968 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
What is the reports view in oracle sql developer?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
how to include numeric values in sql statements? : Sql dba
how to convert numeric values to character strings? : Sql dba
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
How can I make sql query run faster?
What is a loop in sql?
What trigger means?
What is the difference between sql and mysql?
What is primary key and unique key?
How to use sql statements in pl/sql?
how to see the create table statement of an existing table? : Sql dba
Is not equal in sql?
What are the built in functions of sql?
Why primary key is required?
