I'd suggest explicitly referencing each column name in the select instead of doing "select *" as if the schema changes, you could be hiding bugs by using "select *" ...

This repository provides a complete working example of how to implement an XML-based data model using Oracle XML DB. It demonstrates: Registering an XML Schema (XSD) Creating and validating ...