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

How to develop XML report without rdf?

4 Answers   Oracle,


Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen

2 Answers   TCS,


where we find the status of order information.

2 Answers  


Explain the multi-organization structure.

1 Answers   Accenture,


in one report using two layout models.if yes how to do

2 Answers  






When you run he report you have to get only that particular organization po numbers or item number how can do it?

2 Answers   IBM,


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

1 Answers  


How to attach the multiple templates in XML Pub Report?

2 Answers   Intelligroup, KPIT,


what are the sql attributes?

2 Answers  


Do you know where we can check the status of po?

0 Answers  


why we can use synonym?

6 Answers  


What is workflow?Explain with a example?

2 Answers   Oracle,


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)