Answered Questions
Cursor advantages and disadvantages
Asked By: sri3241
| Asked On: Jul 27th, 2009
What are the uses of cursor? what are its advantage and disadvantage?
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
Cursor advantages:--> Using cursor to getting multiple values.--> One cursor have multiple select statements--> Cursor parameters i.e cursor cursor_name (param...
ad:using of cursor ,plsql program can control the context area as sql query result being process
disad:using of cursors we connot go backword (i.e i cannot go to frist record ofter plsql fetch five records form cursor )