Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to retrieve data if the column has XML file

 
gopal kishan
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sorry 2+3columns
 
Maximilian Xavier Stocker
Ranch Hand
Posts: 381
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean file? Is it a BLOB or CLOB field or a link to an actual XML file?
 
gopal kishan
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic