Re: [cx-oracle-users] an old question

[Glyph <gl...@tw...>]

Hi Paul,

On Apr 30, 2013, at 1:40 AM, Paul Moore <p.f...@gm...> 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