Home Forums SQL Server 7,2000 Working with Oracle Cursor use in Oracle RE: Cursor use in Oracle

  • September 12, 2009 at 10:27 pm

    #1052764

    pandeharsh (9/12/2009)

    Hi,

    No ,Sql Server we do not use cursor and also in sql server we can do without cursor.

    But in oracle I see that using cursor is must.

    Also,I read here that,we should avoid cursor as much as possible.

    Can someone put light light on my doubts ?

    Thanks

    Agh... no. A cursor is NOT a must in Oracle except for one spot... if you want to return something to an app, you must use a "reference cursor" because Oracle will not return a result set to an app just using a SELECT. As a side bar, it's best if you put such reference cursors into a package with a global cursor variable.

    Reference cursors are one of the reasons why I don't particularly care for Oracle.

    Another place where you are forced into RBAR is in Oracle triggers... there's no such thing as INSERTED and DELETED tables, just INSERTED and DELETED variables that can only handle one row at a time. If you want to have the trigger handle more than one row, you must use the FOR EACH ROW syntax.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)