Oracle Scenarios Question:
Download Questions PDF

Can we create procedures to fetch more than one record?

Answer:

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.

Download Oracle Scenarios Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is spooling?Schema A has some objects and created one procedure and granted to Schema B.
Schema B has the same objects like schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B?