Metacat

column node format 9999

column pnode format 9999

column nind format 999

column nodetype format a10

column nodename format a11

column nodedata format a23

column docid format a9

column rnode format 9999

select nodeid node, parentnodeid pnode, nodeindex nind, nodetype, 

       nodename, nodedata, docid, rootnodeid rnode

  from xml_nodes order by pnode, nind;