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';