select xml_nodes.docid, xml_index.path, xml_nodes.nodedata, xml_nodes.nodename from xml_index, xml_nodes 
   where xml_index.nodeid=xml_nodes.parentnodeid 
         AND (( xml_index.path like '' AND xml_nodes.nodename like 'packageId') ) 
         AND xml_nodes.docid in   
            ('ABS.4','access.10','access.7','access.8','access.9','ADCP_template.50','adler.3',
             'ALASDatabaseAccess.3','ALEXXX_015ADCP015R00_19990817.50','ALEXXX_015ADCP015R00_19990906.50',
             'ALEXXX_015ADCP015R00_19991108.50') 
         AND xml_nodes.nodetype = 'ATTRIBUTE'