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

Question Posted / askvenki

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

More Oracle Apps Technical Interview Questions

In a Standard form a DFF is disable?How we can Enable it?

Can anybody tell me, What is the Implementation Process?

How to link between inventory and OrderManagement.

we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

what is the need of registering table in apps?

What is Pragma Autonomous transaction. It's Real time Example

what is aim methodolozy

What is MO operating units. Why it need to to set this and where .

After deploying like forms,reports into server how we connect this forms,reports to web?

In custom.pll what are the events we can Not write.

What are profile options?

why do we validate the records while developing interface?

For more Oracle Apps Technical Interview Questions Click Here