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