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;