1.

How Is An Sql Statement Processed? What Are The Steps That An Sql Statement Undergoes For Compilation?

Answer»

SQL STATEMENTS are compiled using the following steps:

  • Parse—Refers to a STEP in which statements are checked for EXISTENCE of all objects used and the SYNTAX is validated.
  • Bind— Refers to a step In which the values for the variables are obtained. This process is also called binding variables.
  • Execute —Refers to a step in which the statement is executed by Oracle.
  • Fetch —Refers to a step in which rows are SELECTED and retrieved one by one until last row is fetched.

SQL statements are compiled using the following steps:


Discussion

No Comment Found

Related InterviewSolutions