Submitted Questions

  • Oracle Query execution

    What is the actual processing being done at backend or server side to retrive the data or complete the DML operation.

    KSPradeep Rayavarapu

    • Jan 28th, 2013

    The order of Query Execution is following
    1)From Clause
    2)Where Clause
    3)Group By Clause
    4)Having Clause
    5)Select
    6)Order By Clause

    Sachin Garg

    • May 22nd, 2012

    Hi Friends, When we pass a SELECT query it executes under some phases. That includes 1) Checking by Server Process - Which type of Query is this - Sql or Pl/sql. 2) If sql - server process puts the ...