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