Rekans, Ada yang punya pengalaman select data dari XML dengan PL SQL ? Aku punya Table : T_TableKU isinya
T_TableKU ( T_TableKU_ID integer, TICKETCONTENT CLOB ) Misal isinya T_TableKU_ID = 45 TICKETCONTENT = <?xml version="1.0"?> <ticketcontent> <TICKETID>TX-20070213-0023</TICKETID> <AGENTNAME>Irwan Husein</AGENTNAME> <AGENTBRANCH>Jakarta</AGENTBRANCH> <AGENTREGION></AGENTREGION> <DATECREATED>2007-02-08 00:00:00.0</DATECREATED> <TIMECREATED>14:34:48</TIMECREATED> <ESCALATIONDATE>2007-02-08 14:35:43.0</ESCALATIONDATE> <LEVEL>REGISTERED</LEVEL> <PROBLEMDATE>2007-02-08 00:00:00.0</PROBLEMDATE> <PROBLEMDESC>Contoh Activity Code ke FOCUS</PROBLEMDESC> <HANDSETTYPE>SONY ERICSSON</HANDSETTYPE> <INFORMATION></INFORMATION> <STATUS>MAINTAIN</STATUS> <HANDLEDBY>IHU</HANDLEDBY> </ticketcontent> Pas select data, emang ga bisa gini yah : SELECT TICKETCONTENT.AGENTNAME FROM T_TableKU He he... ato mesti pake prosedurnya oracle yang seabreg-abreg itu yah? :P ================> HAPUS IKLAN DIATAS DAN FOOTER INI JIKA ME-REPLY <================ Posting : [email protected] Archive : http://www.mail-archive.com/[email protected]/ www.mitek.unibraw.ac.id || himamitek.brawijaya.ac.id ************************************************************************************ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/mitek/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/mitek/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
