oracle 数的构建
摘要:select lpad(' ',4*(level-1))||t.EQU_NAME AS EQU_NAME , t.PARENT_ID, t.equ_id from T_EQU_INFO_TEST t start with t.equ_id IN (SELECT equ_id FROM T_EQU_INFO_TEST WHERE parent_ID IS NULL AND ORGAN_ID= '200511171119415510' ) connect by prior EQU_ID=P...
阅读全文
posted @ 2012-08-23 13:49
浙公网安备 33010602011771号