connect by 与 lapd应用 生成 树形的下拉框数据

SELECT     lb,
              trim(DECODE (LPAD (' ', (LENGTH (lb) / 3 - 1) * 3 + 1, '='),
                      ' ', '',
                      LPAD (' ', (LENGTH (lb) / 3 - 1) * 3 + 1, '=')
                     ))
           || lbmc as lbmc
      FROM tbl_document_type a
CONNECT BY PRIOR parent_lb = lb
ORDER BY lb