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
- 14332 Views
- Fidelity, KCP, I also Faced
- E-Mail Answers
Answer Posted / srinivas
first create new table with the same structure if table_name1
then create a trigger as follws
create or replace trigger <trigger_name>
after update on <table_name1>
for each row
begin
insert into <new_table_name>
values(:new.<column_name1>,:new.<column_nam2>...... );
end;
then update table_name1 table
after that check it new table
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Why we use cross join?
What is composite primary key in sql?
Are null values same as that of zero or a blank space?
How you improve the performance of sql*loader? : aql loader
Why do we use joins?
What is a call statement? Explain with an example.
How can I change database name in sql?
What does 0 mean in sql?
How many sql statements are used?
Can we use delete in merge statement?
How do you write an index?
what is bcp? When is it used?
What is offset and limit in sql?
How to run sql functions in pl/sql?
What sql database should I use?
