Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    32

    Unanswered: Order of executions (Hierarchy)

    Hi
    select s.ename, abc(s.empno, s.deptno) from emp s where s.empno >10 order by 2..

    Kindly tell me the order od execution for above the statementt,

    Execution of Hierarchy

    --------------------------
    we assumed as follows

    function abc , where condition and order by

    Is this correct?

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    no it does the where clause first, then the order by and then your function

    Alan

  3. #3
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Originally posted by AlanP
    no it does the where clause first, then the order by and then your function

    Alan
    no, ORDER BY always performed at the last on the final set of result into the user's PGA.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    whoops your right Hings

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •