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

master table and child table performances and comparisons in Oracle ?

What are inner join and outer join?

Explain the use of indexes option in imp command.

Can we convert a date to char in oracle and if so, what would be the syntax?

How to specify default values in insert statement using oracle?

How do I find the database name in oracle?

What happens if you set the sga too low in oracle?

what is Table ?

How do I limit the number of rows returned by an oracle query after ordering?

What is meant by an index?

How to update values in a table in oracle?

What is the use of file param in imp command?

For more Oracle General Interview Questions Click Here