From: "Jonathan Lewis" <jonat...@jlcomp.demon.co.uk>
Date: Wed, 24 Oct 2012 11:50:02 +0100
Local: Wed, Oct 24 2012 6:50 am
Subject: Re: Does Oracle encourage developers to use cursors?
If you want a useful answer to this question you probably ought to start
It may come down to something as simple as "cursors imply row by row
Author: Oracle Core (Apress 2011)
<gnewsgr...@gmail.com> wrote in messagenews:email@example.com...
| I've asked this at asp.net forum, but I think we have more gurus here to
get more educational, informative information about my confusion.
| I am new to Oracle, but not new to SQL Server and .NET application
development. I think it is a general understanding that we should try to
avoid using cursors as much as possible at least with sql server, because
it just doesn't perform that well.
| But if we read any Oracle PL/SQL primer, I bet you will be reading about
cursors after cursors.
| 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?
| Any thoughts? Thank you.
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.