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
- 15610 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?
What is minus?
How does index help in query performance?
How to use sql*plus built-in timers?
What are the commands used in sql?
What is data modelling in sql?
Explain about various levels of constraint.
Explain the uses of a database trigger?
What are functions in sql?
What is sqlerrd?
what is a view? : Sql dba
What is the life of an sql statement?
When is the update_statistics command used?
what is a primary key? : Sql dba
What is pl sql commands?
