Need Supervisor Hierarchical Query

Hi All,

Please share the query to retrieve supervisor and their subordniates.

For Ex:

  a

    b

    c

      d

       e

         f

         g

    h

If 'a' is supervisor and 'b','c' are sub-ordinates. 'd' and 'e' are subordinates for 'c'. 'f' and 'g' are subordinates for 'e'.

'h' is subordinate for 'a'.

If I pass to the query 'c', all subordniates of 'c' (d,e) and also sub sequent subordniates details(for e-->f,g).

Regards,

Visu