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

佚名 6年前 (2019-05-05) 随笔 1963人围观抢沙发百度已收录

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;