column node format 9999
column pnode format 9999
column nind format 999
column nodetype format a10
column nodename format a15
column nodedata format a23
column docid format 999
column rnode format 9999
select nodeid node, parentnodeid pnode, nodeindex nind, nodetype, 
       nodename, nodedata, docid, rootnodeid rnode
  from xml_nodes order by pnode, nind;