XMLTYPE Extract(*)

 I have following data in the XMLTYPE TABLE

<?xml version="1.0"?> <ipo:parameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ipo="http://www.example.com/IPO" xsi:schemaLocation="http://www.example.com/IPO http://www.example.com/schemas/parameter.xsd"> ipo:parameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ipo="http://www.example.com/IPO" xsi:schemaLocation="http://www.example.com/IPO http://www.example.com/schemas/parameter.xsd">

<RSRV_PARM>

<TargetMin>1000</TargetMin>

<TargetMax>100000</TargetMax>

<TargetIncr>1000</TargetIncr>

</RSRV_PARM>

</ipo:parameters>

</ipo:parameters>

I am doing following query

SELECT r.rp.EXTRACT ('/TargetMin/text()').getstringval() r.rp.EXTRACT