why pl sql doesn't support retrieving multiple records

Question Posted / bmsrao

why pl sql doesn't support retrieving multiple records..

Answer / rahul

pl/sql supports retriving multiple records but u need to
use of cursors. using cursor you can retrieve multiple
records.

Is This Answer Correct ?

24 Yes

3 No

More Oracle General Interview Questions

How to start instance with a minimal initialization parameter file?

How to save query output to a local file?

What are the components of Physical database structure of Oracle Database?

What is an oracle data file?

What is the dynamic sql in oracle?

How to download oracle database 10g xe?

what are views?

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

What is the difference between PFILE and SPFILE in Oracle?

What is a nested table and how is it different from a normal table?

What do you understand by database schema and what does it hold?

How to assign data of the deleted row to variables?

For more Oracle General Interview Questions Click Here