Free Jobs

Java Forums: Core Java (15) J2EE (3) EJB (5) Servlet (3) JDBC (6) Hibernate (2) Struts (1) Swing (1) Oracle (7) JSP (4) Other (10)

Topic: How SQL Statements Executes

To get the Posted Questions details daily in your mail Click Here

Share this Post on Facebook/Twitter/Orkut Bookmark and Share

User: pankaj224 Post Date: 28 Aug 2010 05:27

A SQL statement goes through the following four steps:-

Main Content:
Parse: SQL statement must be parsed. Parsing the statement means checking the statement’s syntax and ensuring that all references to objects are correct, and ensuring that relevant privileges to those objects exist.

Bind: Oracle server knows the meaning of the Oracle statement but still may not have enough information to execute the statement. Therefore, the Oracle server may need values for any bind variable in the statement. The process of obtaining these values is called binding variables.

Execute: After binding variables, the Oracle server has all the necessary information and resources. At this point, the Oracle server executes the statement.

Fetch: In the fetch stage, rows are selected and ordered (if requested by the query), and each successive row retrieves another row of the result until the last row has been fetched. Queries (SELECT statements) can be fetched, but other DML statements cannot be fetched.


About Writer:
Hi , I am Oracle Developer From Banagalore

Writer's Link:

Writer's Email:

Post Comment

Similar Articles Top ArticlesLatest Articles Other Articles by this Author Copyright © 2009-2011 | All Rights Reserved
All content of this website is protected by copyright laws and should not be reproduced in any form or by any means without written permission
(Best viewed in IE 8.0+ or Firefox 3.0+ at resolution of 1024 * 768 or higher)