How is a SQL statement executed?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

Practice Test	Free
	1Z0-147 - Oracle9i: Program with PL/SQL	Download

How is a SQL statement executed?

Rating:

All SQL statements have to go through the following stages:

Parse: Every SQL statement must be parsed. Parsing the statement includes checking the statement's syntax and validating the statement, ensuring that all references to objects are correct, and ensuring that relevant privileges to those objects exist.

Bind: After parsing, the 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.

Note: Some stages can be skipped.

Rating:

Was this information helpful?

Click here to Article home

MCSE: MCSA, MCTS, MCITP JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+
Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g CIW foundation EC-212-32 CISSP Photoshop ACE Adobe Flash ACE

How is a SQL statement executed?

How is a SQL statement executed?

Other articles

Click here to Article home