Question:
What are Drawback of cursor?
Answer:
Cursor fetch the record in a row by row process.It takes some more time.so in oracle 8i there is a concept that is bulk into and bulk bind. Source: CoolInterview.com
Answered by: surendra | Date: 2/12/2008
| Contact surendra
Since it retrieves record by record.So better go for bulk collect. Source: CoolInterview.com
Answered by: Rajiv | Date: 2/20/2008
| Contact Rajiv
In case of cursor,we can't hold much more data.If we hold many data in the cursor ,In that case cursor will be overflowed.we have to work with small set of data. Source: CoolInterview.com
Answered by: sudipta das | Date: 4/16/2008
| Contact sudipta das
Since it retrieves record by record. It takes some more time.so in oracle 8i there is a concept that is bulk into and bulk bind. Source: CoolInterview.com
Answered by: prakash chandra yadav | Date: 5/19/2010
| Contact prakash chandra yadav
Since it retrieves record by record.It takes some more time.so in oracle 8i there is a concept that is bulk into and bulk bind. Source: CoolInterview.com
Answered by: prakash chandra yadav | Date: 5/19/2010
| Contact prakash chandra yadav
Since it retrieves record by record.It takes some more time.so in oracle 8i there is a concept that is bulk into and bulk bind.
Source: CoolInterview.com
Answered by: sohail | Date: 7/25/2010
| Contact sohail
Drawback of Cursor:
Cursor retrieves record by record and as soon as cursor is opened, the very first row from record set is fetched, and cursor moves to another record. so cursor is auto incremental, it automatically fetches next record. Cursor cant be reversed to previous record, so you have to close the cursor and re-open the cursor for fetching the previous records. Source: CoolInterview.com
Answered by: peeyush manke | Date: 8/28/2010
| Contact peeyush manke
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|