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
What is recycle bin in Oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is define in oracle?
What are the oracle built-in data types?
How to invoke the data pump export utility?
What is tns entry?
Explain the truncate in oracle?
What is an oracle cursor variable?
What is Library Cache in Oracle?
What is meant by raw datatype?
What is a select query statement in oracle?
How to insert a record into a table?
What are the database administrators utilities available?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.