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 |
What is an oracle recycle bin?
What is oracle datasource?
What is the relationship among database, tablespace and data file?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
What is RULE-based approach to optimization ?
How to find the duplicate rows count from employees table in oracle?
How are extents allocated to a segment?
How to define an anonymous procedure with variables?
what is the difference between substr and instr function in oracle?
How to bring a tablespace online?
What is a select query statement in oracle?
What are the uses of Database Trigger ?