Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    India
    Posts
    135

    Unanswered: SQLServer Cursor MovePrevious, MoveNext, MoveFirst & MoveLast equ. Method in ORACLE

    In Oracle can we move the cursor First, Last, Previous, Next ?

    Is it Possible in 8i . If Possible Plz. give with sample snippet

    Thanx in advance

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: SQLServer Cursor MovePrevious, MoveNext, MoveFirst & MoveLast equ. Method in ORACLE

    No, Oracle's cursors only support next (fetch).

  3. #3
    Join Date
    Feb 2004
    Location
    India
    Posts
    135

    Re: SQLServer Cursor MovePrevious, MoveNext, MoveFirst & MoveLast equ. Method in ORAC

    Originally posted by andrewst
    No, Oracle's cursors only support next (fetch).
    is there any alternate solution for that method !

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: SQLServer Cursor MovePrevious, MoveNext, MoveFirst & MoveLast equ. Method in ORAC

    If it isn't too much data (e.g. no more than a few hundred rows), you could select it all into a collection (array) and then access the collection in any way you like.

  5. #5
    Join Date
    Feb 2004
    Location
    India
    Posts
    135

    Re: SQLServer Cursor MovePrevious, MoveNext, MoveFirst & MoveLast equ. Method in ORAC

    Originally posted by andrewst
    If it isn't too much data (e.g. no more than a few hundred rows), you could select it all into a collection (array) and then access the collection in any way you like.

    Thanx Tony.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •