How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
XPath expression - → Any XPath expression. The developing XPath 2.0 standard will be a subset of XQuery. XPath 1.0 is
XPath rewrite → Unstructured storage - Function-based indexes can be used to evaluate XPath expressions for … unstructured storage. In addition: In the absence of an XMLIndex index, Oracle XML DB evaluates the XPath … , and then resolves the XPath programmatically using the methods provided by the DOM API. If the … evaluation. Binary XML storage
XPath Interfaces → Processor Interface - basic XPath processor interface that any XPath processor is supposed to … conform to. CompProcessor Interface - extended XPath processor that adds an ability to use XPath … Oracle virtual machine interface. Compiler Interface - XPath compiler into binary representation
XPath rewrite → evaluation is that it much more expensive than XPath rewrite, and does not scale across large numbers … referred to as XPath rewrite. See Chapter 7, \"XPath Rewrite\". The advantage of XPath rewrite is that … it lets Oracle XML DB evaluate XPath-based SQL functions and methods at near relational speeds
7 XPath Rewrite → This chapter explains the fundamentals of XPath rewrite in Oracle XML DB and how to use it for XML … schema-based structured storage. It details the rewriting of XPath-expression arguments to these SQL … . This chapter contains these topics: Overview of XPath Rewrite Where Does XPath Rewrite Occur … ? Which XPath
XPath Rewrite for EXTRACTVALUE → … Function extractValue cannot handle XPath expressions that return multiple values or complexType … elements. Table 7-6 shows the mappings of various XPath expressions for function extractValue. If an … XPath expression targets an element, then extractValue retrieves the text node of the element. For … : both retrieve
XPath Rewrite for XMLSEQUENCE → You can use SQL function XMLSequence in conjunction with SQL functions extract and table to un-nest XML collection values. Foot 1 When used with XML schema-based storage, these functions also get rewritten to access the underlying relational collection storage. For example, this query obtains the price and part numbers of all items in a relational form: SELECT extractValue(OBJECT_VALUE, '/PurchaseOrder/PONum')
XPath Processor Usage Example → ); Create an XPath processor. xptproc = XmlXPathCreateCtx(xctx, NULL, node, 0, NULL); Parse the XPath … expression. exp = XmlXPathParse (xptproc, xpathexpr, &err); Evaluate the XPath expression. obj
Diagnosing XPath Rewrite → This section presents techniques to determine if your XPath expressions are in fact being rewritten.
XPath Rewrite for EXISTSNODE → SQL function existsNode returns one ( 1 ) if the XPath argument targets a nonempty sequence of … differently, depending on the kind of node targeted by the XPath argument: If the XPath argument targets a … the database representation of the element content is NULL. Otherwise, the XPath argument targets a … Document
XPath Construct Description → / Denotes the root of the tree in an XPath expression. For example, /PO refers to the child of the … element that is a grandchild of the PO element. [ ] Used to denote predicate expressions. XPath … root element. Functions XPath supports a set of built-in functions such as substring(), round(), and … not(). In addition, XPath
XPath Expression Maps to → of the SYS_XDBPD$ attribute. Table 7-5 XPath Mapping for EXISTSNODE Without Document Ordering
XPath Maps to → … \"Part\")) FROM table(XMLDATA.\"Item\") p Example 7-17 XPath Mapping for EXTRACT with Document … mapping for function existsNode in the absence of SYS_XDBPD$. Table 7-8 XPath Mapping for EXTRACT Without Document Ordering Preserved
XPath Rewrite Event Trace → You can disable XPath rewrite for views constructed using a SQL/XML function by using the following … XPath rewrite for view constructed using object types, object views, and SQL function sys_XMLGen by … '; You can trace why XPath rewrite does not happen by using the following event flag. The trace
XPath Expression Maps to → /PurchaseOrder CASE WHEN XMLDATA IS NOT NULL THEN 1 ELSE 0 END /PurchaseOrder/@PurchaseDate CASE WHEN XMLDATA.'PurchaseDate' IS NOT NULL THEN 1 ELSE 0 END /PurchaseOrder/PONum CASE WHEN XMLDATA.\"PONum\" IS NOT NULL THEN 1 ELSE 0 END /PurchaseOrder[PONum = 2100] CASE WHEN XMLDATA.\"PONum\" = 2100 THEN 1 ELSE 0 END /PurchaseOrder[PONum = 2100]/@PurchaseOrderDate CASE WHEN XMLDATA.\"PONum\" = 2100 AND
XPath Equivalent to → /PurchaseOrder XMLForest(XMLDATA AS \"PurchaseOrder\") /PurchaseOrder/@PurchaseDate XMLForest(XMLDATA.\"PurchaseDate\" AS \"PurchaseDate\") /PurchaseOrder/PONum XMLForest(XMLDATA.\"PONum\" AS \"PONum\") /PurchaseOrder[PONum = 2100] SELECT XMLForest(XMLDATA AS \"PurchaseOrder\") FROM DUAL WHERE XMLDATA.\"PONum\" = 2100 /PurchaseOrder [PONum = 2100]/@PurchaseDate SELECT XMLForest(XMLDATA.\"PurchaseDate\"
ora:contains XPath Function → table purchase_orders. ora:contains XPath Function Function ora:contains is an Oracle-defined XPath … function for use in the XPath argument to the SQL functions existsNode, extract, and extractValue. The
Overview of XPath Rewrite → expressions is called XPath rewrite. This optimization enables the use of B-tree or other indexes, if … present on the column, to be used in query evaluation by the Optimizer. This XPath rewrite mechanism … is used for XPath-expression arguments to SQL functions such as XMLQuery, XMLTable, XMLExists … , existsNode, extract, extractValue,
XPath Expression Maps to → simpleType Elements An XPath expression can contain a text() node test, which targets the text node … example, the XPath expression \" /PurchaseOrder/PONum/text() \" maps directly to the SQL column XMLDATA … . The XPath \" /PurchaseOrder/PONum \" also maps to the SQL column XMLDATA.\"PONum\". However, in this … case, XPath
XPath Rewrite for EXTRACT → SQL function extract retrieves XPath results as XML. For Xpath expressions involving text nodes … -7 shows the mapping of various XPath expressions inside extract expressions when document order is … ). Table 7-7 XPath Mapping for EXTRACT with Document Ordering Preserved
XPath and Oracle XML → and update XML content stored in Oracle Database. They use the W3C XPath Recommendation to identify … the required node or nodes. Each node in an XML document can be uniquely identified by an XPath … expression. An XPath expression consists of a slash-separated list of element names, attributes names, and … XPath
Which XPath Expressions Are Rewritten? → An XPath expression can generally be rewritten if all of the following are true: The SQL function … methods existsNode() and extract(), none of the corresponding XMLType methods can be rewritten. The XPath … can be rewritten. XPath predicates can be rewritten to SQL predicates. The XML Schema constructs … for the XPath
Common Storage Constructs Supported in XPath Rewrite → The following storage constructs are supported for XPath rewrite: Simple numeric types that are
XPath Expression for Translation Description → Simple XPath expressions: /PurchaseOrder/@PurchaseDate /PurchaseOrder/Company Involves traversals … CREATE INDEX operation. Predicates: [Company = \"Oracle\"] Predicates in the XPath are rewritten into … . Wildcard traversals: /PurchaseOrder/*/Part If the wildcard can be translated to a unique XPath (for example … expression.
Unsupported Storage Constructs in XPath Rewrite → The following XML Schema storage constructs are not supported. This means that if an XPath … XML schema maps part of an element definitions to a SQL CLOB instance, then XPath expressions that traverse such elements are cannot be rewritten
How Are XPath Expressions Rewritten? → in the column, and the SYS_XDBPD$ attribute can be used to distinguish the two cases. The XPath
XPath Rewrite for INSERTCHILDXML and DELETEXML → XPath Rewrite for UPDATEXML SQL function updateXML must satisfy the following conditions for it to … SET OBJECT_VALUE = updateXML(OBJECT_VALUE,...); XPath arguments must all be different (no duplicates … ). XPath arguments must otherwise be rewritable, as described in \"Which XPath Expressions Are … Rewritten?\".
Using EXPLAIN PLAN with XPath Rewrite → This section shows how you can use EXPLAIN PLAN to examine query plans after XPath rewrite. See … \"Understanding and Optimizing XPath Rewrite\" for how to use EXPLAIN PLAN to optimize XPath rewrite … use events to understand why XPath rewrite did not occur — see \"Using Events with XPath Rewrite
XPath Rewrite of Individual SQL Functions → This section details XPath rewrite for SQL functions existsNode, extractValue, extract, XMLSequence
Common XML Schema Constructs Supported in XPath Rewrite → In addition to standard XML Schema constructs such as complexType elements and sequences, the following XML Schema constructs are also supported. This is not an exhaustive list. Collections of scalar values, where the scalar values are used in predicates. Simple type extensions containing attributes. Enumerated simple types. Boolean simple type. Inheritance of complex types. Substitution groups.
XPath Rewrite Can Change Comparison Semantics → For the most part, there is no difference between rewritten XPath queries and functionally … evaluated ones. However, since XPath rewrite uses XML Schema information to turn XPath predicates into SQL … predicates, comparison of nonnumeric entities is different. In XPath 1.0, the comparison operators … . With XPath
Where Does XPath Rewrite Occur? → XPath rewrite occurs for the following SQL functions: deleteXML existsNode extract extractValue … insertChildXML updateXML XMLExists XMLQuery XMLSequence XMLTable XPath rewrite can happen when these … . Example 7-4 SELECT Statement and XPath Rewrite This example returns the existing purchase orders … Company is not Oracle. Example
Unsupported XML Schema Constructs in XPath Rewrite → The following XML Schema constructs are not supported. This means that if an XPath expression … : XPath expressions accessing children of elements that contain any content. When nodes contain any … namespace specified in the XPath. The any attributes are handled in a similar way. Data-type operations
Rewriting XPath Expressions: Mapping Data Types and Path Expressions → This section describes the mapping of XPath expressions to SQL data types and path expressions … . Mapping for a Simple XPath Expression A rewrite for a simple XPath expression involves accessing the … SQL column corresponding to the expression, as shown in Table 7-2. Table 7-2 Simple XPath Mapping for purchaseOrder
Using Events with XPath Rewrite → statement. The XML events can be used to turn off functional evaluation, turn off the XPath rewrite … instead evaluated functionally. The error ORA-19022 - XML XPath functions are disabled will be raised … existsNode(OBJECT_VALUE, '/PurchaseOrder[Company+PONum=\"Oracle\"]')=1. ERROR: ORA-19022: XML XPath … file explaining that
XPath → XML Path Language (XPath), based on a W3C recommendation, is a language for addressing parts of an
XPath → The open standard syntax for addressing elements within a document used by XSL and XPointer. XPath
Overview of XPath Function ora:contains → XPath function ora:contains can be used in an XPath expression inside an XQuery expression or in a … search with a full-text predicate. It extends XPath through a standard mechanism: it is a user-defined … an XQuery expression, the XQuery return type is xs:integer(). when used in an XPath expression … outside
XPath Rewrite on XMLType Views → XPath rewrite for XMLType views constructed using XMLType tables or object types, object views, and … -relational accesses for better performance. XPath rewrite for XMLType views constructed using the … view columns get rewritten into underlying relational accesses for better performance. See Also: Chapter 7, \"XPath Rewrite\"
Understanding and Optimizing XPath Rewrite → XPath rewrite improves the performance of SQL statements containing XPath-based functions by … optimizer from having to understand the XPath notation and the XML data model. The database optimizer … SQL statements with XPath-based functions with near relational performance. For XPath rewrite to take