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
Cite the differences between execution of triggers and stored procedures?
How do I make sql search faster?
What is sql basics?
Explain how to use transactions efficiently : transact sql
What is crud sql?
How delete a row in sql?
How to run sql*plus commands in sql developer?
What does t sql mean?
Can we call a function containing dml statements in a select query?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Is sql developer case sensitive?
Why do we create views in sql?
How do I order columns in sql?
How do I run a sql query in pgadmin 4?
How many types of cursors supported in pl/sql?