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

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

0 Answers   IBM,


whats the use of after parameter form and before report?

2 Answers   IBM,


How can we import the data into a database using sql * loader?

0 Answers  


What r the validation types?

3 Answers  


How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers   Oracle,






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

1 Answers   Accenture,


Is that Possible To create package Overloading , If Yes Give any Examples

1 Answers   PWC,


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

0 Answers   Tech Mahindra,


what is difference between po_headers_all and po_headers

2 Answers   NTT Data,


What is menu.

2 Answers   Accenture,


The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.

7 Answers   SGS,


i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.

1 Answers   IBM, Sierra Atlantica,


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)