Re: an old question
Glyph <glyph-wgPraSjSqjuEakHPNWoOSQC/[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
Hi Paul, On Apr 30, 2013, at 1:40 AM, Paul Moore <[email protected]> wrote: > This may be basic stuff you already know, but for purposes of clarity, Oracle runs statements in 3 steps - parse, execute and fetch. Only select statements need a fetch phase, all other statements run in the execute phase. Think of it as "only select statements produce a cursor you can fetch from" if you like. Everything else you said in your message was interesting, and I learned a lot from all of it, but this paragraph really nailed my problem. In fact, I did not know about these 3 steps, and I didn't realize that the cursor was (effectively) synthesized as a result of the execution of the 'select'. In other database I've dealt with, query execution works somewhat differently, and I was bringing that expectation to Oracle. Thanks a ton! -glyph ------------------------------------------------------------------------------ Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET Get 100% visibility into your production application - at no cost. Code-level diagnostics for performance bottlenecks with <2% overhead Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap1 _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users