HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?

Question Posted / askvenki

2 Answers
8394 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?..

Answer / mylapuram

USE SQL%ROWCOUNT to find whether any records are updated.

IF SQL%ROWCOUNT =0 then

-- no records are updated
else
-- records are update

Is This Answer Correct ?

14 Yes

0 No

HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?..

Answer / hari

BY USING IMPLICIT CURSOR ATTRIBUTES

Is This Answer Correct ?

6 Yes

0 No

Post New Answer

More Oracle Apps Technical Interview Questions

What is procedure?

3 Answers IBM,

Tell me some errors names and number what u got while developing the reports?

1 Answers

How can a process be deployed in soa?

0 Answers

what is lexical parameter?

3 Answers TCS,

Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .

1 Answers TCS,

how to call report from oracle oracle apps11i?

3 Answers Genpact,

where the accounting related data is stored ?

2 Answers

what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.

3 Answers Scan Steel,

How to link between inventory and OrderManagement.

1 Answers Zensar,

how to debug the report?

2 Answers IBM, Qualcomm, Sierra Atlantica,

How to create a purchase order without a requisition?

0 Answers

How will u register concurrent request ?

1 Answers Convergys,

For more Oracle Apps Technical Interview Questions Click Here