⟩ Can we create procedures to fetch more than one record?
We can create a procedure to return REF cursor or VARRAY or PL/SQL Table type out parameters which can return more than one value.
Question and Answer:
Home Oracle Scenarios
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Explain What is an UTL_FILE.What are different procedures and functions associated with it?
Explain Which is more faster - IN or EXISTS?
How to find out nth highest salary from emp table?
Explain What should be the return type for a cursor variable. Can we use a scalar data type as return type?
Select the Nth lowest value from a table?
Explain What is the purpose of a cluster?
Explain Difference between procedure and function.?
Explain Which datatype is used for storing graphics and images?
Explain Difference between an implicit and an explicit cursor?
Explain ROWID?
