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?
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
Is id a reserved word in sql?
Does sqlite need a server?
Write the alter statement to enable all the triggers on the t.students table.
What is a sql statement?
How to change the order of columns in Oracle SQL Plus ?
How many sql statements are used?
what is 'trigger' in sql? : Sql dba
What is keys and its types?
Why is sharding used?
How does postgresql compare to "nosql"?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What does joining a thread mean?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Can function return multiple values in sql?
what is the difference between myisam static and myisam dynamic? : Sql dba