Oracle interview question

Technical one: SQL hierarchical query.