This post originated from an RSS feed registered with Java Buzz
by IT-eye weblog.
Original Post: Using XMLType, XMLDB and XQuery
Feed Title: IT-eye Weblog
Feed URL: http://www.it-eye.nl/weblog/feed/
Feed Description: Where Oracle meets Java
This is a small example for a coworker, but maybe someone else can also benefit from it. This question was “can we store multiple xml document types in one column and easily query on xml contents”?
First create a table with an XMLType column, and insert some data:
SQL> create table mydocs
( id number [...]