Last post Jan 29, 2019 09:37 AM by 20141113
Oct 08, 2017 03:02 PM|20141113|LINK
i am using oracle 12g. and my table structure has two column, 1st is ID of the record, 2nd column is defined as XMLTYPE.
now the data stored in XMLTYPE is like a xml format. but i don't know how can i write a sql to retrieve the tag to column.
below is my example.
every data stored in XMLTYPE is not fixed lenght. how can i write a sql to convert above xml format to column as below expected result.
Gender F M
Oct 08, 2017 04:24 PM|20141113|LINK
i know the exactvalue can do that, but it can't return if xml has 3 node name as <c4>, <c4 m='2'>,<c4 m='3'>
how can i get the value from xmltype?
Oct 11, 2017 12:08 AM|Lannie|LINK
Jan 29, 2019 09:37 AM|20141113|LINK