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
- 15623 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
What is int identity in sql?
How to download oracle sql developer?
Is json a nosql?
Differentiate between sga and pga.
Explain the purpose of %type and %rowtype data types with the example?
Is sql harder than python?
What is a parameter query?
What does pl sql developer do?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What are different types of sql commands?
What is normalization in a database?
Difference between truncate, delete and drop commands?
Is sql workbench free?
How to use transactions efficiently : transact sql
How to use boolean type in select statement?
