rotem_fo's query is just fine, but with that query you can not control order of a query.

Don't worry, I was just wondering I there is a way to control order of hierarhical query with SQL on 8i.

Thank you all for replays

Aljaz