xml as a record not data source

lpurba

Hi all,
I was wondering if I can parse or do something to my data if the data is an xml.

Let say I have a table student with student_id, student_property fields.
The student_id id is a regular record, let say, 123, and student_property is an xml record, let say
<?xml version="1.0" encoding="UTF-8"?>
<name>
<firstname>John</firstname>
<lastname>Doe</lastname>
<dob>10/01/1919</dob>
</name>

Is there any way that I can display student_property not as an xml in my table? I know I can have xml as a data source, but I don't think this one can be considered as xml data source.

Regards,
-Laurent