SQL & PL/SQL

Hi All,

I know 'connect by' precedes 'where clause'. And I can use a test case to test this.

But I can't figure out which comes first, connect by and group by.

Can someone give me some tips on this, pleaes?

And another confusion of mine is execution sequence of select and order by.

In my opinion, since order by can read the alias of selected column, I think the sequence is that oracle select rows first and then sort them.

Please correct or confirm my statement.

Best regards,

Leon