Thanks for the question, Usha S.
Asked: July 24, 2017 - 10:41 am UTC
Last updated: July 31, 2017 - 3:09 am UTC
Version: 12.1.0.2.0
Viewed 1000+ times
for i in ( SELECT A.PID,A.MSG_EMPDETAILSDETAILS.getClobVal() FROM IMPP.EMPLOYEE A WHERE A.EMPLOYEENUMBER IN ( SELECT EMPLOYEENUMBER FROM XMLTABLE (xmlnamespaces('urn:global:cs:common' AS "tns0"), '/tns0:Request' PASSING XMLType(in_xml) COLUMNS baselist XMLTYPE PATH 'tns0:Conditions') t1, XMLTABLE (xmlnamespaces('urn:global:cs:common' AS "tns0"), 'tns0:Conditions/tns0:Numbers/tns0:Number' PASSING t1.baselist COLUMNS EMPLOYEENUMBER VARCHAR2(88) PATH 'text()') xmlT ) ) loop ... end loop; end;
Usha S, July 27, 2017 - 2:51 pm UTC
New to good database design? Check out Chris Saxon's full fundamentals class.