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

Can we protect our pl/sql source code?

568


What is a dynamic performance view in oracle?

594


How to define an external table with a text file?

572


Explain the use of rows option in imp command.

600


What happens in oracle commit?

555






What is a trace file and how is it created in oracle?

541


How to create tables for odbc connection testing?

485


What is a proxy class?

549


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1172


What is MTTR advisor in Oracle?

598


What do database buffers contain?

557


Can you have more than one content canvas view attached with a window ?

1811


Can we convert a date to char in oracle and if so, what would be the syntax?

543


What is an oracle?

567


Explain an integrity constrains?

692