Majid,
You've got a good part of it. The DB doesn't actually do a precompile & all
that, but the idea is straight. In a nutshell Oracle:
1: checks the statement for syntax errors
2: checks to see if the objects (tables & views) exist
3: checks to see if you have access rights on the objects referenced
4: check to see if the column names are right
5: builds and evaluates the possible data access paths, it has to choose one
and only one At this point we're into Pcode.
6: If you requested a 'group by' or 'order by' in the statement a temporary
table will be created & the data buffered for a burst delivery
OR else the data is sent record by record as they are qualified.
Dick Goulet
____________________Reply Separator____________________
Author: Majid Kazemi <[EMAIL PROTECTED]>
Date: 3/15/2001 12:02 PM
Hi guys:
I need some clarification on how Oracle complie a statement (sql or pl
Sql).. I believe it first precompile then compile and finally execute. Also
how Oracle will return the query result. Does it return it as a stream? Or
it save it somewhere in ( example:a temp table ) before return it to client.
Your help will highly be appreciated.
Thanks;
Majid Kazemi
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Majid Kazemi
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).