Re: Does Oracle encourage developers to use cursors?
Date: Sat, 20 Oct 2012 18:32:49 -0700 (PDT)
Message-ID: <35b936a4-a9c2-45b0-8db0-bec09d6f0bce_at_n16g2000yqi.googlegroups.com>
gnew:
# So, is cursor simply the established practice of Oracle to get our data?
Yup.
# 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