I know that an intact XML document can be stored in a CLOB in ORACLE’s XML solution. Can XML documents stored in a CLOB/BLOB be queried like table schema? For example: [XML document stored in BLOB]…lee jumee… Can value(lee, jumee) be queried by elements, attributes and the structure of XML document? If some element or attribute is inserted/updated/deleted, must the whole document be updated? Or can insert/update/delete function as in table schema? About locking, if we manage an XML document stored in a CLOB/BLOB, can nobody access the same XML document? Answer Using Oracle Text (intermedia Text), you can find this document with a query such as: lee within first or this:jumee within second or this:1111 within name@id you can combine these like this: lee within first and jumee within secondor this:(lee within first) within name. For more information, please read the “interMedia Text Technical Overview” for 8.1.5 and 8.1.6 availa
