oracle 查询 当前及以下

--排查掉是不是数据问题
--再看sql
SELECT * FROM T_PUB_JGDM START WITH N_JGDM = '43000086'  CONNECT BY PRIOR N_JGDM = N_SJJG;
SELECT *  FROM T_PUB_JGDM WHERE C_JGLB LIKE '%43000086%';

 

--机构链表:用于回溯;国家局->省公司->市公司->网点 的机构列表
SELECT C_JGLB,o.* FROM T_PUB_JGDM o WHERE C_JGLB LIKE '%43000086%';
SELECT * FROM t_pub_jgdm o WHERE o.n_jgdm IN('43000086','4399931Q');