Answer Posted / a.v.bhaskar reddy
REF CURSOR is majorly used when we want to execute a
dynamic select statement causes to retrieve more than one
record. We can pass Ref cursor result as a out parameter
which can be used in other subprograms
| Is This Answer Correct ? | 28 Yes | 4 No |
Post New Answer View All Answers
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
Tell me where we find the status of order information?
Can we create tables in apps schema?
what are the prerequisites for costing transactions?
what are the different transaction clauses in AR?
List the various types of value set.
how do you describe O2C along with tables
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Do you know what is applysys in oracle application database schema, what is apps?
Do you know where we can check the status of po?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
where to define interorganization transaction charges and what are the different options?
how can i print random rows in plsql table
is it possible to run the interface without using oracle apps?
What are file in oracle.