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
- 15620 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 the maximum number of triggers, you can apply on a single table?
Why stored procedure is faster than query?
What is record variable?
what is acid property in database? : Sql dba
What are the parameter modes supported by pl/sql?
How do I order by ascending in sql?
Why we use joins in sql?
Where the sql database files are stored?
Why is sql better than hql?
Can you have a foreign key without a primary key?
Explain scalar functions in sql?
What do you mean by table in sql?
What is dialect in sql?
Can we create table inside stored procedure?
What is the maximum number of rows in sql table?
