Oracle Schema's are basically, as I understand it, user groups. Schema's can contain user-defined types, or abstract data types (ADTs), that essentially contain other datatypes within each ADT; sometimes the ADTs contain other ADTs from other schemas/user-groups.
XMLTypes allow for a user to submit an xml document to a database, where the internal XML data is then etxracted. Different applications allow for said XML doc's to be stored as CLOB vs. relational etc.
XML Schema's define a set pattern that xml files must follow to be considered that specific 'type' of xml;
So this is where I'm confused. Can you convert an ADT to an XMLType?
I can create an XML schema to refer to a specific pattern of XML--essentially an XML object, instead of an ADT, but the only datatype I can specify in a table for Oracle 10g is an XMLType. Once I have created an XML Schema, shouldn't I be able to refer to that schema as an object?
No comments:
Post a Comment