Metacat

column node format 9999

column pnode format 9999

column nind format 999

column nodetype format a10

column nodename format a15

column nodedata format a25

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

       nodename, nodedata 

  from xml_nodes order by pnode, nind;