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 EXISTSNODE


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


Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.xdb.dom

existsNodepublic boolean existsNode(java.lang.String xpath, java.lang.String nsmap) throws

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 40 of 177

EXISTSNODESyntax existsnode::= Text description of existsnode Purpose EXISTSNODE determines whether traversal … WHERE EXISTSNODE(warehouse_spec, '/Warehouse/Docks') = 1; WAREHOUSE_ID WAREHOUSE_NAME

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

EXISTSNODEEXTRACT (XML)

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Using XMLType

existsNode FunctionThe syntax for the existsNode() function is described in Figure 4-2 and also as follows: existsNode … NUMBER Figure 4-2 existsNode() Syntax Text description of the illustration existsnode.gif … existsNode() function on XMLType checks if the given XPath evaluation results in at least a single XML … namespace(s).

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Using Oracle XML DB

Using existsNode()The existsNode() syntax is shown in Figure 3-1. Figure 3-1 existsNode() Syntax Text description of … the illustration existsnode.gif Example 3-4 existsNode() Examples That Find a Node to Match the … XPath Expression Given this sample XML document, the following existsNode() operators return true (1 … ). SELECT

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Structured Mapping of XMLType

XPath Expression Rewrites for existsNode()existsNode() returns a numerical value 0 or 1 indicating if the XPath returns any nodes ( text() or … element nodes). Based on the mapping discussed in the earlier section, an existsNode() simply … the scalar column. existsNode Mapping with Document Order Maintained Table 5-12 shows the mapping of … various XPaths in the case

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Searching XML Data with Oracle Text

Querying XML Data: Use CONTAINS or existsNode()?important semantic differences between the CONTAINS operator and the existsNode() function. The … existsNode, extract() and extractValue() SQL functions (and the corresponding member functions of XMLType … Text CONTAINS() and existsNode() searching. Table 7-6 lists and compares CONTAINS() and existsNode … () features

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Searching XML Data with Oracle Text

Oracle XML DB: Using CTXXPATH Indexes for existsNode()The existsNode() SQL function, unlike the CONTAINS operator, cannot use ConText indexes to speed up … its evaluation. To improve the performance of XPath searches in existsNode(), this release … designed to serve as a primary filter for existsNode() processing, that is, it produces a superset

Reference, 9i Release 2 (9.2.0.2)

CTX_DDL Package

CREATE_POLICYan XPATH query expression with existsNode. See Also: Oracle9i XML Developer's Guide - Oracle XML DB

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

Syntax for CTXXPATH IndextypeCreate this index when you need to speed up ExistsNode() queries on an XMLType column. CREATE INDEX

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

CTXXPATH Examples('storage my_storage memory 40M'); Querying the table with ExistsNode: select xml_id from xml_tab x

Reference, 9i Release 2 (9.2.0.2)

CTX_DDL Package

Example=> 'mystop', wordlist => 'mywordlist'); Then you can issue the following ExistsNode() query with your … own defined policy: select id from xmltab where existsNode(doc, '/book/chapter[ ora:contains

Application Developer's Guide - Advanced Queuing, 9i Release 2 (9.2.0.2)

Introduction to Oracle Advanced Queuing

XMLType Payloadsqueue Query XMLType columns using the operators ExistsNode() and SchemaMatch() Specify the operators in subscriber rules or dequeue conditions

New Features, 9i Release 2 (9.2.0.2)

Oracle9i Database Release 2 (9.2) New Features

Oracle TextStem Indexing Chinese Lexer URIType indexing CTXXPATH ORA:CONTAINS Support in ExistsNode() Document … indexes on URIType columns. CTXXPATH The CTXXPATH indextype enables you to speed up ExistsNode … () queries on XMLType columns. ORA:CONTAINS Support in ExistsNode() You can call the CONTAINS function … within an ExistsNode()

Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.xdb.dom

Methodsthe XMLType. extract Function to extract the given set of nodes from the XMLType. existsNode Function

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 43 of 177

EXTRACT (XML)EXISTSNODE function. It applies a VARCHAR2 XPath string and returns an XMLType instance containing an XML

XML API Reference - XDK and Oracle XML DB, 9i Release 2 (9.2.0.2)

Generating Queries Using DBMS_XMLGEN for PL/SQL

getXML()returns it as a sys.XMLType. XMLType operations can be performed on the results, including ExistsNode … results, including ExistsNode and Extract. This also provides a way of obtaining the results as a

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_XMLGEN, 2 of 2

getXML()sys.XMLType. XMLType operations can be performed on the results, including ExistsNode and Extract … , including ExistsNode and Extract. This also provides a way of obtaining the results as a string by using the

XML API Reference - XDK and Oracle XML DB, 9i Release 2 (9.2.0.2)

What's New with XML Enabled Technology?

XML Database Features Introduced in Oracle9 i Release 2 (9.2)Updates extract(), existsNode(), and extractValue() support namespace-based operation. extract … (), existsNode(), and extractValue() support the full XPath function set, including axis operators … query and as part of the existsNode() function. CTXXPATH is a new index type for use with … existsNode() to speedup

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

Purposethis index when you need to speed up ExistsNode() queries on an XMLType column. See Syntax for