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

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

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

0 Answers  


How to attach the multiple templates in XML Pub Report?

2 Answers   Intelligroup, KPIT,


In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers   Accenture,


Can 2 functions have same name & input parameters but differ only by return datatype ?

5 Answers  


Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,






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

1 Answers  


in ap_terms table what data will be stored

1 Answers  


what is pick selection list generation report.

3 Answers  


do i need to declare bind parameter before using in the query?

2 Answers   Satyam,


What are do's and dont's of Interface?

0 Answers  


what are the sql attributes?

2 Answers  


while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?

9 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)