分析存储过程片段

Question

http://www.oracle.com/technology/global/cn/oramag/webcolumns/2003/techarticles/gennick_connectby_10g.html
http://oracle.chinaitlab.com/exploiture/391832.html
http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/gennick_connectby.html

Answer 1

以SELECT processobject FROM da_depprocobject
          WHERE processtype = TO_NUMBER(i_righttype) AND
          department = i_department
这个查询的结果开始构造树。