Home » Developer & Programmer » JDeveloper, Java & XML » Need help to optimize the extract value from XML Type
Need help to optimize the extract value from XML Type [message #91964] Tue, 30 December 2003 23:57
sara
Messages: 36
Registered: February 2000
Member
Actually i am extracting Data from XML Type column i am using xmltype.extract function. but it is taking 15 sec to 30 sec for extracting 235 row only. anybody give some help to optimize this query

select xmltype.extract(value(t), '//ITEM_CODE/text()').getstringval() as code,
xmltype.extract(value(t), '//AMOUNT/text()').getstringval() as amt
from XMLREPOSITORY,
table( xmlsequence( extract(RETURN_XML,'/CALL_REPORT/BODY/ITEMS_INFO'))) t
Previous Topic: using a java to grant a user problem!
Next Topic: Doubt in JDBC.
Goto Forum:
  


Current Time: Wed Aug 04 01:17:49 CDT 2021