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

Question Posted / askvenki

2 Answers
7441 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

Can you have two stored functions with in the same name?

3 Answers

How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?

2 Answers Deloitte, Intelligroup,

Hi Experts How to Create a purchase order without a requisition ?

6 Answers Amdocs, KPMG, Oracle,

is it possible to run the interface without using oracle apps?

2 Answers Accenture,

what is the use of placeholer column?

3 Answers

how can we get odd numbered pages in output of a report

2 Answers Infosys,

why r u move in the cus_top only why not move another top

4 Answers Wipro,

How to move the one file from one instance to another instance? And your scripts also?

0 Answers

What is the reason for distribution hold. Why invoices will go on distribution variance hold ??

1 Answers Oracle,

What is function?

2 Answers Motorola,

can we pass bind variablein lexical parameter?

1 Answers BirlaSoft,

what is difference between API and Interface?

2 Answers Infogain,

For more Oracle Apps Technical Interview Questions Click Here