You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for XPath


1 to 20 of 418 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


XML Developer's Kit Programmer's Guide, 11g Release 1 (11.1)

Using the XPath Processor for C++

XPath InterfacesProcessor 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

XML DB Developer's Guide, 11g Release 1 (11.1)

Introduction to Oracle XML DB

XPath rewriteUnstructured 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

XML DB Developer's Guide, 11g Release 1 (11.1)

Using XQuery with Oracle XML DB

XPath expression -Any XPath expression. The developing XPath 2.0 standard will be a subset of XQuery. XPath 1.0 is

XML DB Developer's Guide, 11g Release 1 (11.1)

Using Oracle XML DB

XPath rewriteevaluation 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

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

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

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

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

XML Developer's Kit Programmer's Guide, 11g Release 1 (11.1)

Using the XSLT and XVM Processors for C

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

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

XPath Expression Maps tosimpleType 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

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

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

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

XPath Rewrite for XMLSEQUENCEYou 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')

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

7 XPath RewriteThis 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

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

XPath Rewrite for EXTRACTSQL 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

XML DB Developer's Guide, 11g Release 1 (11.1)

XMLType Operations

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

XML DB Developer's Guide, 11g Release 1 (11.1)

Using Oracle XML DB

XPath and Oracle XMLand 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

XML DB Developer's Guide, 11g Release 1 (11.1)

Full-Text Search Over XML Data

ora:contains XPath Functiontable 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

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

XPath Expression Maps toof the SYS_XDBPD$ attribute. Table 7-5 XPath Mapping for EXISTSNODE Without Document Ordering

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

Overview of XPath Rewriteexpressions 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,

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

XPath Rewrite for EXISTSNODESQL 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

XML DB Developer's Guide, 11g Release 1 (11.1)

XPath Rewrite

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\"

XML DB Developer's Guide, 11g Release 1 (11.1)

XMLType Views

XPath Rewrite Event TraceYou 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