select ’01040000’ as high_position, ’MENU14’ as menu_id,’2’as lvl,’’ as menu_rgt from dual
union all
select ’01040100’ as high_position, ’/IF/S_IF_InqryList.jsp’ as menu_id,’3’as lvl,’/IF/S_IF_InqryList.jsp’ as menu_rgt from dual
union all
select ’01010000’ as high_position, ’MENU11’ as menu_id,’2’as lvl,’’ as menu_rgt from dual
union all
select ’01010100’ as high_position, ’MENU111’ as menu_id,’3’as lvl,’’ as menu_rgt from dual
union all
select ’01010101’ as high_position, ’/HC/S_HC12_PermApprList.jsp’ as menu_id,’4’as lvl,’’ as menu_rgt from dual
union all
select ’01010103’ as high_position, ’/HC/S_HC_PermUpdList.jsp’ as menu_id,’4’as lvl,’’ as menu_rgt from dual
union all
select ’01010200’ as high_position, ’MENU112’ as menu_id,’3’as lvl,’’ as menu_rgt from dual
union all
select ’01010201’ as high_position, ’/HC/S_HC22_StartworkApprList.jsp’ as menu_id,’4’as lvl,’’ as menu_rgt from dual
union all
select ’01010203’ as high_position, ’/HC/S_HC_StartworkUdpList.jsp’ as menu_id,’4’as lvl,’’ as menu_rgt from dual
union all
select ’01010300’ as high_position, ’MENU113’ as menu_id,’3’as lvl,’’ as menu_rgt from dual
union all
select ’01010301’ as high_position, ’/HC/S_HC32_CompApprList.jsp’ as menu_id,’4’as lvl,’’ as menu_rgt from dual
union all
select ’01010303’ as high_position, ’/HC/S_HC_CompUdpList.jsp’ as menu_id,’4’as lvl,’’ as menu_rgt from dual
union all
select ’01010102’ as high_position, ’/HC/S_HC12_PermApprDtls.jsp’ as menu_id,’4’as lvl,’/HC/S_HC12_PermApprDtls.jsp’ as menu_rgt from dual

이런식의 데이터에서 하위 래밸의 menu_rgt 값이 널이 아닌경우 상태컬럼을 주어 표시하고 싶습니다.
/IF/S_IF_InqryList.jsp 경우 코드가 01040100 이며 상위 코드는 01040000 입니다.
 /HC/S_HC12_PermApprDtls.jsp 경우 01010102 이며 상위코드는 01010100,01010000 입니다.
위에 나오는 상위코드와 자신을 포함해서 상태를 표시해야합니다.

어찌보면 간단한 방법이 있을듯한대..지금현재 menu_rgt 이 있는 테이블에 임의의 플래그를 줘서 조인해 판달할수있도록 구현하였는대 좀더 쉬운방법이 없을까요.

전체매뉴 조인 권한있는메뉴(임의플래그) 형식으로 현재는 값을 가져오고 있습니다.
오라클 함수로 간단하게 될꺼 같은대  영모르겠군요...