SELECT A.*,
LEVEL,
CONNECT_BY_ISLEAF,
CONNECT_BY_ROOT GC_CJJH_ID JD
FROM GC_CJJH A
WHERE A.dxzx in ('0','2')
and a.sfyx = '1'
START WITH A.GC_CJJH_ID IN
(SELECT A.GC_CJJH_ID
FROM GC_CJJH A
WHERE A.Parentid =
(select b.gc_cjjh_id
from gc_cjjh b
where b.parentid = 'root'
and sfyx = '1')
and sfyx = '1')
CONNECT BY PRIOR A.GC_CJJH_ID = A.PARENTID
LEVEL,
CONNECT_BY_ISLEAF,
CONNECT_BY_ROOT GC_CJJH_ID JD
FROM GC_CJJH A
WHERE A.dxzx in ('0','2')
and a.sfyx = '1'
START WITH A.GC_CJJH_ID IN
(SELECT A.GC_CJJH_ID
FROM GC_CJJH A
WHERE A.Parentid =
(select b.gc_cjjh_id
from gc_cjjh b
where b.parentid = 'root'
and sfyx = '1')
and sfyx = '1')
CONNECT BY PRIOR A.GC_CJJH_ID = A.PARENTID