Hi.

Remember, there are several ways of dealing with XML including:

- Search it with XPATH.
- Manually traverse the DOM tree.
- Convert it to an XML type and query the contents with SQL.
- Use XMLDB to load the data into a table for you.

The options you can pick depend on which of Oracle you are using along with your preferences. These articles might help:

http://www.oracle-base.com/articles/...cles9i.php#XML

Cheers

Tim...