Re: Does Oracle encourage developers to use cursors?

From: John Hurley <>
Date: Sat, 20 Oct 2012 18:32:49 -0700 (PDT)
Message-ID: <>


# So, is cursor simply the established practice of Oracle to get our data?


# Is oracle cursor internally different from that of SQL Server such that it doesn't cause any performance hit?

Don't think you are going to get too many people here chiming in on any "internal differences" ... cursors in Oracle been around for well before any reasonable person considered moving any significant application onto SQL Server.

Lots of good reading in the Oracle land ...

Start with the free concepts manual from Oracle.

Try this one on for size ( by Tom Kyte ): Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions

Another good architecture book by Jonathan Lewis: Oracle Core: Essential Internals for DBAs and Developers

Try just to learn how Oracle works do not try to compare everything with any other database. Received on Sun Oct 21 2012 - 03:32:49 CEST

Original text of this message