The following query can be used to return all the Oracle Portal pages within a particular page branch, including the level at which they appear in the tree.

SELECT

  id "ID",

  level "LEVEL",

  parentid "PARENTID",

  name "NAME",

  title "TITLE"



  FROM wwpob_page WHERE siteid=999 AND base_type=1

  

  CONNECT BY PRIOR id=parentid

  START WITH id=11111 AND siteid=999

  ORDER SIBLINGS BY TITLE;

where "11111" is the starting page id and "999" is the site id (page group id). Additional columns from the wwpob_page table can be added as required.

If you want to include a durable URL to each page you can include the following column in the SELECT statement :

'http://www.example.com:7780/portal/page/mydb/' || guid "URL"

Obviously you will have to modify the URL as appropriate to your system.