SQL & PL/SQL

Hi,

I would like to perform a hierarchical query based on a leaf node condition for example; in the below query/results, If the leaf node name starts  in 'S' I want to remove this leaf-node and remove the parent providing it doesn't have any other leaf nodes that don't start with 'S', and apply the same criteria up the chain..

In the below example, SMITH starts with S, so I want to remove it, and then remove FORD because it has no other non-'S' child records. SCOTT stays, because its not a leaf node and therefore ADAMS stays too

SELECT empno, LPAD(' ', LEVEL * 2) ||  ename ename, mgr

   FROM emp

   START WITH empno  = 7839

   CONNECT BY PRIOR empno = mgr;