This SQL is for hierarchical Trees but I dont understand it.
Its ont the oracle university book.
select 1, level, ename, NULL, to_char(empno)
from emp
connect by prior empno = mgr
start with job =''PRESIDENT''
I dont understand why select 1,
AND I also dont understand the last 2 lines. connect by prior and start with??
thanks
