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
- 15967 Views
- Fidelity, KCP, I also Faced
- E-Mail Answers
Answer Posted / sandeeptiwari1111@gmail.com
We can achieve this w/o using any Trigger also.
For this result you just need to put your update statement inside this below block
begin
----Your udate statement
dbms_output.put_line(sql%rowcount);
end;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Why should I use postgresql?
Explain how exception handling is done in advance pl/sql?
Does mysql support pl sql?
What is schema in sql?
How can you load multi line records? : aql loader
Why use triggers in sql?
How do I view a sql trace file?
What is difference between procedure and trigger?
What are the datatypes available in pl/sql ?
What is trigger with example?
what are the join types in tsql? : Transact sql
Is left join same as inner join?
How can I speed up sql query?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What are the 3 modes of parameter?
