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 40 of 418 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


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)

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 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)

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

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

Diagnosing XPath RewriteThis section presents techniques to determine if your XPath expressions are in fact being rewritten.

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)

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)

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

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)

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

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 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)

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

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 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 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)

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)

XPath Rewrite

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

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

XPath Rewrite

Common Storage Constructs Supported in XPath RewriteThe following storage constructs are supported for XPath rewrite: Simple numeric types that are

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

XPath Rewrite

XPath Expression for Translation DescriptionSimple 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.

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

XPath Rewrite

Unsupported Storage Constructs in XPath RewriteThe 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

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

XPath Rewrite

How Are XPath Expressions Rewritten?in the column, and the SYS_XDBPD$ attribute can be used to distinguish the two cases. The XPath

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

XPath Rewrite

XPath Rewrite for INSERTCHILDXML and DELETEXMLXPath 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?\".

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

XPath Rewrite

Using EXPLAIN PLAN with XPath RewriteThis 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

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

XPath Rewrite

XPath Rewrite of Individual SQL FunctionsThis section details XPath rewrite for SQL functions existsNode, extractValue, extract, XMLSequence

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

XPath Rewrite

Common XML Schema Constructs Supported in XPath RewriteIn 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.

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

XPath Rewrite

XPath Rewrite Can Change Comparison SemanticsFor 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

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

XPath Rewrite

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

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

XPath Rewrite

Unsupported XML Schema Constructs in XPath RewriteThe 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

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

XPath Rewrite

Rewriting XPath Expressions: Mapping Data Types and Path ExpressionsThis 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

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

XPath Rewrite

Using Events with XPath Rewritestatement. 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

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)

Glossary

XPathXML Path Language (XPath), based on a W3C recommendation, is a language for addressing parts of an

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

Glossary

XPathThe open standard syntax for addressing elements within a document used by XSL and XPointer. XPath

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

Full-Text Search Over XML Data

Overview of XPath Function ora:containsXPath 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

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

XMLType Views

XPath Rewrite on XMLType ViewsXPath 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\"

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

Using Oracle XML DB

Understanding and Optimizing XPath RewriteXPath 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