why pl sql doesn't support retrieving multiple records

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert numbers to characters in oracle?

590


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1590


Explain the use of rows option in exp command.

585


What is user managed backup in Oracle?

615


How to connect to the server with user account: sys?

566






How to bring a tablespace online?

520


What are the different types of modules in oracle forms?

562


Hi Can any one tell me what are the API's used in requisition import.

1487


What is an external table?

588


State the difference between a primary key and foreign key?

518


How do I find my oracle client driver version?

528


How to import one table back from a dump file?

595


Explain self joins in oracle?

563


What is hot backup and logical backup?

610


What happens if the imported table already exists?

549