I have a column with xml data stored as a varchar2.

I have a solution in SQL SERVER but do not know how to achieve the result in ORACLE. Below is a snipet of the xml and the result.

declare @x XML =
'<NewDataSet>
<XMLData>
<task_id>111</task_id>
<template_id>1</template_id>
<project_id>2</project_id>
<field_id>81687</field_id>
<section_id>9346</section_id>
<ext_attribute_id>75</ext_attribute_id>
<col_num>1</col_num>
<row_span>2</row_span>
<sequence>1</sequence>
<encoded_title_id>1044634</encoded_title_id>
<value_type>9</value_type>
<encoded_list_id>55</encoded_list_id>
<AT13602>Multiple Brand Selection:</AT13602>
<attribute_value>Baraclude (entecavir) - 686</attribute_value>
</XMLData>
<XMLData>
<task_id>111</task_id>
<template_id>1</template_id>
<project_id>2</project_id>
<field_id>81688</field_id>
<section_id>9347</section_id>
<ext_attribute_id>223</ext_attribute_id>
<col_num>1</col_num>
<row_span>1</row_span>
<sequence>1</sequence>
<encoded_title_id>1045112</encoded_title_id>
<value_type>10</value_type>
<encoded_list_id>189</encoded_list_id>
<AT13602>Training Content Type:</AT13602>
<attribute_value />
</XMLData>
<XMLData>
<task_id>111</task_id>
<template_id>1</template_id>
<project_id>2</project_id>
<field_id>81690</field_id>
<section_id>9348</section_id>
<ext_attribute_id>84</ext_attribute_id>
<col_num>1</col_num>
<row_span>1</row_span>
<sequence>2</sequence>
<encoded_title_id>1044682</encoded_title_id>
<value_type>10</value_type>
<encoded_list_id>64</encoded_list_id>
<AT13602>Promotional/Non-Promotional:</AT13602>
<attribute_value>Promotional</attribute_value>
</XMLData>
</NewDataSet>
'

select
t.value('(task_id/text())[1]', 'int') as task_id,
'extvalue' + t.value('(ext_attribute_id/text())[1]', 'nvarchar(50)') as ext_attribute_id,
t.value('(attribute_value/text())[1]', 'varchar(max)') as attribute_value
FROM
( select @x x) xdata
CROSS APPLY
x.nodes('//XMLData') AS task(t)


RESULT

task_id ext_attribute_id attribute_value
111 extvalue75 Baraclude (entecavir) - 686
111 extvalue223 NULL
111 extvalue84 Promotional

Thanks,
Bill