存储过程用到的表、分组、排序、联结

查询存储过程用到的表，并进行分组、排序、联结：

 SELECT  
      REFERENCED_OWNER,
      REFERENCED_NAME,
      LISTAGG(XH||'>'||NAME,',') WITHIN GROUP(ORDER BY  XH ) NAME 
 FROM 
     ( 
        SELECT 
        A.REFERENCED_OWNER, 
        A.REFERENCED_NAME, 
        A.NAME ,
        ROW_NUMBER() OVER(PARTITION BY A.REFERENCED_OWNER, A.REFERENCED_NAME ORDER BY A.NAME DESC ) XH 
        FROM USER_DEPENDENCIES A   --系统表
        WHERE A.REFERENCED_OWNER IN ('IRS_MODEL', 'IRS_ODS','ADMDATA') --根据实际用户
        AND TYPE IN ('PROCEDURE'/*, 'VIEW'*/) --实际类别
        AND A.NAME LIKE 'PMODEL_DS%' --实际名称
        ORDER BY A.REFERENCED_OWNER,A.REFERENCED_NAME
      )
  GROUP BY REFERENCED_OWNER,REFERENCED_NAME;