SELECT ID , OKC_TREE_INDEX.GET_ID(LEVEL , SECTION_SEQUENCE) SECTION_INDEX , OKC_TREE_INDEX.GET_ID_LPADED(LEVEL , SECTION_SEQUENCE , 5 , 2) SECTION_ORDER FROM OKC_SECTIONS_B CONNECT BY PRIOR ID = SCN_ID START WITH CHR_ID = OKC_TREE_INDEX.GET_ROOT_ID AND SCN_ID IS NULL