<NS1:ExchangeRateDownloadResponseIo xmlns:NS1="http://www.ru/CurrencyExchange">
<NS1:exchagneRateRecords>
<centerRate>22.37330000</centerRate>
<currencyCode>AUD</currencyCode>
<currencyUnit>1</currencyUnit>
<exchangeRateTableTypeCode>CBR</exchangeRateTableTypeCode>
<refCurrencyCode>RUR</refCurrencyCode>
<refCurrencyUnit>1</refCurrencyUnit>
<validFrom>2007-10-10</validFrom>
</NS1:exchagneRateRecords>
<NS1:exchagneRateRecords>
<centerRate>50.94890000</centerRate>
<currencyCode>GBP</currencyCode>
<currencyUnit>1</currencyUnit>
<exchangeRateTableTypeCode>CBR</exchangeRateTableTypeCode>
<refCurrencyCode>RUR</refCurrencyCode>
<refCurrencyUnit>1</refCurrencyUnit>
<validFrom>2007-10-10</validFrom>
</NS1:exchagneRateRecords>
</NS1:ExchangeRateDownloadResponseIo>
Помогите распарсить и преобразовать в таблицу. Проблема с неймспейсами, без них всё понятно
select
extractvalue(value(d), '/exchagneRateRecords/centerRate') col1,
extractvalue(value(d), '/exchagneRateRecords/currencyCode') col2,
extractvalue(value(d), '/exchagneRateRecords/currencyUnit') col3,
extractvalue(value(d), '/exchagneRateRecords/validFrom') col4
from table(XMLSequence(XMLType(
'<ExchangeRateDownloadResponseIo>
<exchagneRateRecords>
<centerRate>22.37330000</centerRate>
<currencyCode>AUD</currencyCode>
<currencyUnit>1</currencyUnit>
<exchangeRateTableTypeCode>CBR</exchangeRateTableTypeCode>
<refCurrencyCode>RUR</refCurrencyCode>
<refCurrencyUnit>1</refCurrencyUnit>
<validFrom>2007-10-10</validFrom>
</exchagneRateRecords>
<exchagneRateRecords>
<centerRate>50.94890000</centerRate>
<currencyCode>GBP</currencyCode>
<currencyUnit>1</currencyUnit>
<exchangeRateTableTypeCode>CBR</exchangeRateTableTypeCode>
<refCurrencyCode>RUR</refCurrencyCode>
<refCurrencyUnit>1</refCurrencyUnit>
<validFrom>2007-10-10</validFrom>
</exchagneRateRecords>
</ExchangeRateDownloadResponseIo>').extract('ExchangeRateDownloadResponseIo/exchagneRateRecords'))) d;
субд 9.2.0.8