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
- 14352 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
How to add new employee details in an employee_details table with the following details
What is localdb mssqllocaldb?
What are the various restrictions imposed on view in terms of dml?
Explain some predefined exceptions.
what is the difference between group by and order by in sql? : Sql dba
What do you mean by stored procedures? How do we use it?
What are the 3 types of behavioral triggers?
What is the left table in sql?
How do I view stored procedures?
What is a crud api?
What is on delete restrict?
what is self join and what is the requirement of self join? : Sql dba
Explain the order of sql statement execution?
how can we repair a mysql table? : Sql dba
how to show all tables with 'mysql'? : Sql dba
