First given that you are on 11.2, ExtractValue is deprecated and the documentation lists three options to use instead. Here is one option (untested)
SELECT owner, object_name, object_type, object_id, created FROM db_objects do, XMLTable('/ROWSET/THISROW' PASSING do.object_value COLUMNS -- Set data types accordingly owner VARCHAR2(20) PATH 'owner', object_name VARCHAR2(20) PATH 'object_name', object_type VARCHAR2(20) PATH 'object_type', object_id VARCHAR2(20) PATH 'object_id', created VARCHAR2(20) PATH 'created');
Second, why does column order matter? You are storing in an object relational method. As long as the XML is valid per the schema, the Oracle will be able to store the data and later retrieve it as well. How that data is stored is mostly Oracle internals and should not be touched as it can be changed from version to version. You can use schema annotation to control how Oracle maps and stores the XML, but nothing in there specifies column order that I am aware of.
It seems additional details are missing as to what you need the information for so that would help others answer your question.
Thanks...got the underlying structure.