Metacat

column nodeid format 9999

column par format 9999

column idx format 999

column nodetype format a10

column nodename format a10

column nodedata format a10

column root format 9999

column docid format a10

select nodeid, parentnodeid par, nodeindex idx, nodetype, nodename, nodedata, rootnodeid root, docid from xml_nodes where docid = '&docid';