After update how do u know how many records got updated

Answer Posted / pkd

Except sql%rowcount,using returning clause with count()
function

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to concatenate two text values in oracle?

691


Can select statements be used on views in oracle?

672


How does the on-delete-cascade statement work?

702


Explain the use of online redo log files in oracle.

670


What is the simplest tool to run commands on oracle servers?

596






What is the string concatenation operator in oracle?

656


Is truncate autocommit in oracle?

743


List out the difference between commit, rollback, and savepoint?

713


Explain an index segment?

731


Why do you use stored procedures and state some of its disadvantages?

664


I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

706


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1883


How to select an oracle system id (sid)?

668


Explain the use of consistent option in exp command.

625


How to insert a record into a table?

742