APEX

Hi,

I have the following

select case when connect_by_isleaf = 1 then 0
            when level = 1             then 1
            else                           -1
       end as status, 
       level, 
       "LAST_NAME" as title, 
       null as icon, 
       "EMPLOYEE_ID" as value, 
       null as tooltip, 
       null as link 
from "#OWNER#"."V_X"
start with "EMPLOYEE_ID" = 100
connect by prior "EMPLOYEE_ID" = "MANAGER_ID"

Can I insert under certain node a value?
How can I add more column e.g. hire_date, salary etc?

Thank you