how to retrieve data if the column has XML file

[gopal kishan]

HI All,

My table contain 3 column(id, name,TicketAttr(XML FILE)), 3rd column contain XML file which contain 3 tags(version, status, empID).

now i want to display the 3+3 columns. how to retrive the data???

please let me know...

thanks in advance
Gopal

[gopal kishan]

sorry 2+3columns

[Maximilian Xavier Stocker]

What do you mean file? Is it a BLOB or CLOB field or a link to an actual XML file?

[gopal kishan]

Hi

Its type is sys.xmltype.

i can able to get all the column if i use extractValue() function in oracle and i give get the result based on id, or name.

but i want to get result base on empID(which is a tag property in XML file)