- SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label), ' > ')) ,' > ') PATH
- 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 in ('PROCESS_NAME_HERE') )
- CONNECT BY PRIOR PORTAL_PRNTOBJNAME = portal_objname;
Get process's navigation path by using process name
最新推荐文章于 2022-05-03 12:37:34 发布