pl/sql supports retriving multiple records but u need to use of cursors.

why pl sql doesn't support retrieving multiple records

Question Posted / rahul

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Is truncate autocommit in oracle?

1035

What is oracle update statement with inner join ?

1004

What are the limitations of check constraint?

973

What is oracle and what are its different editions?

1015

Is there a combination of "like" and "in" in sql?

1013

Explain the use of log option in exp command.

1056

Explain an exception?

938

What are the most common interview questions on ETL Testing for experience?

1082

How do you tell what your machine name is and what is its IP address?

2015

Explain an extent?

1053

What do you mean by a deadlock?

1017

How to execute a stored procedure in oracle?

1036

Is rowid unique in oracle?

949

How to use "out" parameter properly?

1030

How to generate query output in html format?

1049