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?
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 a delimiter in sas?
What is the difference between left and left outer join?
Why is normalization important?
What is sap sql?
What is fmtonly in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Explain exception handling in pl/sql?
What is rank dense_rank and partition in sql?
what are all the different types of indexes? : Sql dba
what is acid property in database? : Sql dba
What are secondary keys?
when MSQL8.0 is in market
explain the advantages and disadvantages of stored procedure? : Sql dba
What is foreign key and example?
Can we join tables without foreign key?