zhaiyongling的专栏

CREATE TABLE T_INFO (        T_PERSON_ID NUMBER,        T_PERSON_NAME VARCHAR(20),        T_TYPE_ID VARCHAR(200) ); INSERT INTO T_INFO  SELECT 1, '张三', '1,2' FROM DUAL UNION ALL  SELECT 2, '李四

SELECT A.*,                        LEVEL,                        CONNECT_BY_ISLEAF,                        CONNECT_BY_ROOT GC_CJJH_ID JD                   FROM GC_CJJH A                  WHERE A.