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
Why does for update in oracle 8 cause an ora-01002 error?
What is the string concatenation operator in oracle?
How to delete an existing row from a table in oracle?
What is an oracle?
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.
How can Oracle users be audited?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is an Oracle index?
How will you identify oracle database software release?
What are the data types in oracle?
6. Display the client name and order date for all orders using the traditional method.
How are extents allocated to a segment?
How to drop an existing table in oracle?
How would you change old and new values in an insert, delete and update triggers?