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
- 15823 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
What is scope of pl sql developer in future?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
How do I count duplicates in sql?
How is sql used in oracle?
How to display Row Number with Records in Oracle SQL Plus?
what is normalization? : Sql dba
What is the use of pl/sql table?
Why is nosql good?
What is the difference between sql and mysql?
Why query optimization is needed?
How global cursor can be declare with dynamic trigger ?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
If a cursor is open, how can we find in a pl/sql block?
What is varchar data type in sql?
What is write ahead logging in sql server?
