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;