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 / 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
How do I run a pl sql procedure in sql developer?
What is the use of non clustered index?
Why do we need cursors in pl sql?
Explain clause in sql?
How many types of relationship are there?
What are the two types of exceptions.
how can we destroy the cookie? : Sql dba
how can I make a script that can be bi-language (supports english, german)? : Sql dba
How does postgresql compare to mysql?
How do you determine the current isolation level? : Transact sql
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is auto increment in sql?
What is the difference between left and left outer join?
What is dynamic sql in pl sql?
What is clustered and nonclustered index in sql?
