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

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  


What is MTTR advisor in Oracle?

0 Answers   MCN Solutions,


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

0 Answers   Oracle, TCS,


what are archived logs?

0 Answers  






Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

0 Answers   Microsoft,


How to open a cursor variable?

0 Answers  


What are a collation and state the different types of collation sensitivity?

0 Answers  


i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 Answers  


Difference between varchar and varchar2 data types?

0 Answers  


What are transaction isolation levels supported by oracle?

0 Answers  


What is a subquery?

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)