-
What is the use of cursors in PL/SQL ? What is REF Cursor ?
The cursor are used to handle multiple row query in PL/SQL. Oracle uses implicit cursors to handle all it’s queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with REF cursors you can define a cursor variable which will point to that memory space and can be used like pointers in our 3GLs.
-
-
-
Order Management Process
In the Order Management Process, When does the pick status of a line become cancelled or how to set the pick status of a line as cancelled. (Please explain step by step as I am a beginner.)
-
Oracle Apps Basics Interview Questions
Ans