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 蔡成 阅读(108) 评论(0) 推荐(0) 编辑