Cursor use in Oracle

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Working with Oracle » Cursor use in Oracle

11 posts, Page 2 of 2

««1 2

Cursor use in Oracle

Rate Topic

Display Mode

Topic Options

Author

Message

Jeff Moden

Posted Friday, May 20, 2011 3:42 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:57 PM
Points: 32,906, Visits: 26,790

PaulB-TheOneAndOnly (5/19/2011)

Jeff Moden (3/12/2011)

I absolutely agree but, just like I said a year and a half ago, too many people simply give up too easily on finding a high performance set based solution. Tongue

Aleluya! I waited a year and a half for your reply and I was certain it will come sooner or later BigGrin

By the way, I do agree.

You waited for the wrong thing then because I said exactly the same thing that year and a half ago. Wink

Jeff Moden (10/10/2009)

PaulB-TheOneAndOnly (9/22/2009)

pandeharsh (9/12/2009)

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

This is not correct. Is like saying you should avoid surgery as much as possible - why if surgery is your most effective alternative?

Actually, that is not entirely correct... Heh... I find that too many people go for "elective surgery" instead of finding the better way.

You should indeed avoid cursors "as much as possible". I'll agree that it's sometimes not possible but most folks simply give up too early.

--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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1112785

« Prev Topic | Next Topic »

11 posts, Page 2 of 2

««1 2

Permissions