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

In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,


what is the difference between varchar and varchar(2)?

4 Answers  


what is the use of format trigger?a

3 Answers  


If there is any issue then whom do you report.(this is imp question for every interview)

3 Answers   Accenture,


where we find the status of order information.

2 Answers  






What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,


What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,


Explain what are the tables of auto invoice?

0 Answers  


What is the link between AP and GL in oracle apps R/12?

4 Answers   Bosch, Collabera, Synechron,


how i can create temporary table?

1 Answers   Zensar,


How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,


I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,


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)