PeopleSoft Oracle Database 通过AE名称查询门户导航路径

W15862852993

于 2019-05-05 15:59:00 发布

阅读量202

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/aGameOfCode/p/10813515.html

版权

SELECT DISTINCT 'Portal Root -> ' || RTRIM(REVERSE(SYS_CONNECT_BY_PATH(REVERSE(PORTAL_LABEL),
                                                                       ' >- ')),
                                           ' >- ') "Navigation by Process Name"
  FROM PSPRSMDEFN
 WHERE PORTAL_NAME = 'EMPLOYEE'
   AND PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'
 START WITH PORTAL_URI_SEG2 IN
            (SELECT DISTINCT PNLGRPNAME
               FROM PS_PRCSDEFNPNL
              WHERE PRCSNAME = UPPER(&PRCSNAME))
CONNECT BY PRIOR PORTAL_PRNTOBJNAME = PORTAL_OBJNAME;