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

Question Posted / askvenki

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

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,

What do you understand by soa and what are the benefits of using this architecture?

0 Answers

what are the functions you are used in utl_file at the time of transferring the data?

2 Answers Oracle,

WHAT IS REFCURSOR IN ORACLE ?

6 Answers

what are the tables of auto invoice.

2 Answers

whats the use of after parameter form and before report?

2 Answers IBM,

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers

how can u link a org-id with a responsibility in reports?

2 Answers TCS,

What are the tables in GL?

3 Answers Convergys,

why we can use synonym?

6 Answers

35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?

2 Answers Accenture,

tell me the scenarios of the independent in reports

0 Answers TCS, Wipro,

For more Oracle Apps Technical Interview Questions Click Here