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
- 15816 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
The select into statement is most often used to create backup copies of tables or for archiving records?
What is java sql package?
How do I find duplicates in sql?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What are commit, rollback, and savepoint?
What is embedded sql what are its advantages?
what are wild cards used in database for pattern matching ? : Sql dba
What are packages in pl sql and also explain its advantages?
What does select count (*) mean in sql?
Explain the difference between triggers and constraints?
Can we rollback truncate?
What are the possible values for the boolean data field?
What does an inner join do?
how to get a list of columns in an existing table? : Sql dba
List and explain the different types of join clauses supported in ansi-standard sql?
