aspose file tools*
The moose likes JDBC and the fly likes how to retrieve data if the column has XML file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to retrieve data if the column has XML file" Watch "how to retrieve data if the column has XML file" New topic
Author

how to retrieve data if the column has XML file

gopal kishan
Ranch Hand

Joined: Feb 23, 2005
Posts: 99
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

Joined: Feb 23, 2005
Posts: 99
sorry 2+3columns
Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
What do you mean file? Is it a BLOB or CLOB field or a link to an actual XML file?
gopal kishan
Ranch Hand

Joined: Feb 23, 2005
Posts: 99
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)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to retrieve data if the column has XML file