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
- 15811 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
Which sql statement is used to delete data from a database?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is the use of non clustered index?
What are different sql data types?
How do I know if I have sql express or standard?
Why do we use set serveroutput on?
Is sqlite thread safe?
What is sql architecture?
Explain autonomous transaction.
What are the set operators in sql?
How does cross join work in sql?
Can a foreign key be null?
What are the two types of cursors in pl sql?
Why stored procedure is better than query?
What are the constraints available in sql?
