why pl sql doesn't support retrieving multiple records



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

Post New Answer

More Oracle General Interview Questions

What is an oracle recycle bin?

0 Answers  


What is oracle datasource?

0 Answers  


What is the relationship among database, tablespace and data file?

0 Answers  


19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,


What is RULE-based approach to optimization ?

1 Answers  


How to find the duplicate rows count from employees table in oracle?

0 Answers  


How are extents allocated to a segment?

0 Answers  


How to define an anonymous procedure with variables?

0 Answers  


what is the difference between substr and instr function in oracle?

0 Answers  


How to bring a tablespace online?

0 Answers  


What is a select query statement in oracle?

0 Answers  


What are the uses of Database Trigger ?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)