بیشترتوضیحاتافزودن یادداشت جدیدCharacter Large Object (CLOB), as data without tags distributed in object-relational tables or as both. You can use Oracle Text to perform searches on XML documents stored in CLOBs.Note A CLOB is one of the Oracle internal Large Objects (LOBs) whose value is composed of character data and can store up to 4GB of data. Meanwhile, a VARCHAR2 column in a table has a limit of 4000 bytes, and a VARCHAR2 in a PL/SQL variable has a limit of 32767 bytes (32K).CLOBs can be indexed to search the XML as plain text or as document sections for more precise searches. For example, you can find Oracle WITHIN <title>, ignoring it elsewhere in the document. Oracle Text also provides full-text indexing of documents and the capability to do SQL queries over documents, along with XPATH-like searching. Finally, Oracle’s Advanced Queuing (AQ) now supports XML-based message queuing in the database, supporting both synchronous and asynchronous communications of XML messages defined in the standard Simple Object Access Protocol (SOAP) format for both the server and client.
لطفا منتظر باشید ...
