如何找出component的注册路径

SELECT DISTINCT REVERSE(LTRIM(SYS_CONNECT_BY_PATH(REVERSE(PORTAL_LABEL),                                                   ' >- '),                               ' >- ')) "NAVIGATION"   FROM PSPRSMDEFN P  WHERE PORTAL_OBJNAME = 'PORTAL_ROOT_OBJECT'  START WITH PORTAL_URI_SEG2 = 'C_PUNCH_EXPET'   /*要找的component的名称*/ CONNECT BY PRIOR PORTAL_PRNTOBJNAME = PORTAL_OBJNAME        AND PORTAL_NAME = PRIOR PORTAL_NAME        AND PORTAL_REFTYPE = 'F'  具体链接： http://peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/how-to-know-the-navigation-for-a-particular-component-or-page-1641481#M1641958

转载于:https://www.cnblogs.com/bryanchen/p/3385900.html