1
  • Bulk Collect loop and Cursor Loop

    Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks

    Nikhildhar35 pointsBadges:
  • ‘Swirl’ cursor

    My cursor is usually an arrow. Sometimes, by itself, it will change to a 'swirl' and then it drags the screen around when I try to move cursor. Eventually it will change back to arrow by itself again and work as it should. What is going on and how do I stop this from happening? I do not speak...

    sailor64455 pointsBadges:
  • Have to move cursor to enter.

    When I type a number for a command, the cursor remains on the last number so I have to move it before enter key works. How do I get it past the last # of command so I can simply hit enter?

    gaffneyd5 pointsBadges:
  • How do I remove a symbol attached to my cursor

    have a page? symbol attached to my cursor. how to remove it?

    Bpmitchell95 pointsBadges:
  • Alternatives to cursors in SQL Server

    What are the alternatives to cursors? I can’t find any other method to move through record sets one at a time.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Cursor and subfile

    I am using a cursor to get records for display through a per-page-loading subfile.  I am using a host structure to get the records.  My problem is how to "position to" a specific record.  Cursors do not support functionality similar to what a SetLL and ReadE can do. When I close, prepare a new...

    bogeybetsy560 pointsBadges:
  • What causes ora-00904 error on valid fields when querying across dblink in a cursor

    I have a procedure that contains a cursor that runs in a cursor for loop. The select query runs fine over the dblink all by itself, but when I try to compile the procedure, I get the PL/SQL: ORA-00904: invalid identifier on the column names. I can do a describe on the table over the link and all of...

    Tom msu15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following