2012年8月23日

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

导航