my xmltype data in table
<row id='1'><a55 m="45">R1</a55><a55 m="45" s="2">R2</a55><a55 m="45" s="3">R3</a55></row>
i am using below script but it concate all value,how can i separate it by column or give a space if concate all value
SELECT XMLCAST(XMLQUERY('/row/c55[(@m=''45'')]/text()' PASSING C.XMLCOL RETURNING CONTENT) AS VARCHAR(35)) from table_1 C
existing output
R1R2R3
how can i output it in sepearte column per row.
id 55_1 55_2 55_3
--- ------ ------- --------
1 R1 R2 R3