-- Get all sub-folders and components under a certain folder name --
SELECT PORTAL_NAME,
   PORTAL_PRNTOBJNAME AS FOLDER,
   PORTAL_OBJNAME AS CONTENT_REFRENCE,
   PORTAL_LABEL,
   PORTAL_URI_SEG1 AS MENU,
   PORTAL_URI_SEG2 AS COMPONENT,
   PORTAL_URI_SEG3 AS MARKET,
   portal_reftype
FROM psprsmdefn
 WHERE portal_name = 'EMPLOYEE'
 START WITH PORTAL_LABEL = ':1' CONNECT BY PRIOR portal_objname = portal_prntobjname
 GROUP BY PORTAL_NAME,
 portal_reftype,
   PORTAL_PRNTOBJNAME,
   PORTAL_OBJNAME,
   PORTAL_LABEL,
   PORTAL_URI_SEG1,
   PORTAL_URI_SEG2,
   PORTAL_URI_SEG3
   ORDER BY portal_reftype DESC;
-- PORTAL_NAME is your folder name
-- You might get better results if you know the portal object name. Replace "START WITH PORTAL_LABEL = ':1'" with "START WITH PORTAL_OBJNAME = ':1'"