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

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

What is the difference between buyer&employee in PO module?

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

why do we validate the records while developing interface?

What are the validations you don in .CTL file in inbound interface process?

Difference between Bind and Lexical parameters?

Is it possible calling from one report to another? if possible means tell me ?

What are the files we submit while your program move to testing instance?

Oracle E-Business suite?

HOW CAN U KNOW THE STAUS OF PO?

what is the invoice matching

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

For more Oracle Apps Technical Interview Questions Click Here