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 XQuery


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


SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

XQUERY

XQUERYSyntax XQUERY xquery_statement The SQL*Plus XQUERY command enables you to perform an XQuery 1.0 … query on a specified database. XQUERY is supported on Oracle Database 10 g (Release 2) and later … versions. Attempting to use XQUERY on an earlier version of the Oracle Database gives the error: SP2-614

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

ODP.NET XML Support

XQuery SupportBeginning with Oracle Database 10 g release 2(10.2), ODP.NET supports the XQuery language through a … native implementation of SQL/XML functions, XMLQuery and XMLTable. When executing XQuery statements … , Oracle XML DB generally evaluates XQuery expressions by compiling them into the same underlying … XQuery-specific

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

XQuery ExpressionsExceptions to this desirable mathematical property include the following: XQuery expressions that … might change). In some cases, like that of fn:doc, XQuery is defined to be referentially transparent … argument results in the same document. XQuery expressions that are defined to be dependent on the … particular XQuery

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

ora:contains XQuery Functionora:contains Syntax ora:contains (input_text, text_query [, policy_name] [, policy_owner]) XQuery … and XPath function ora:contains can be used in an XQuery expression in a call to SQL/XML function … higher the number, the more relevant the match), and zero otherwise. When used in an XQuery expression … (that is not also an XPath

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

Performance Tuning for XQueryA SQL query that involves XQuery expressions can often be rewritten (optimized) in one or more ways … . This optimization is referred to as XML query rewrite or optimization. XPath expressions are a proper subset of XQuery expressions.

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

ora:sqrt XQuery Functionora:sqrt Syntax ora:sqrt (number) XQuery function ora:sqrt returns the square root of its numeric … argument, which can be of XQuery type xs:decimal, xs:float, or xs:double. The returned value is of the same XQuery type as the argument.

SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

SET System Variable Summary

SET XQUERY CONTEXT {text}Specifies an XQuery context item expression. A context item expression evaluates to the context … ]), or an atomic value (as in the expression (1 to 100)[. mod 5 eq 0]). To unset the XQUERY CONTEXT … , set an empty string, for example: SET XQUERY CONTEXT '' Take care to enter valid values as values are … checked only when an XQUERY

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

ora:matches XQuery Functionora:matches Syntax ora:matches (target_string, match_pattern [, match_parameter]) XQuery function … code that qualifies matching: case-sensitivity and so on. The behavior of XQuery function ora:matches … is the same as that of SQL condition REGEXP_LIKE, but the types of its arguments are XQuery types

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

ora:tokenize XQuery Functionora:tokenize Syntax ora:tokenize (target_string, match_pattern [, match_parameter]) XQuery function … separator indicating where to split. It returns the sequence of tokens as an XQuery value of type

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

When To Use XQuerya complete XQuery expression, possibly including a prolog, as a literal string. The value of the … expression serves as input to the XMLTable function; it is this XQuery result that is decomposed and … followed by the keyword AS and an XQuery identifier. The result of evaluating each expr is bound to … description). The optional

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

ora:replace XQuery Function]) XQuery function ora:replace lets you use a regular expression to replace matching text in a string … that qualifies matching: case-sensitivity and so on. The behavior of XQuery function ora:replace is … the same as that of SQL function regexp_replace, but the types of its arguments are XQuery types

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

Diagnosing XQuery Optimization: XMLOptimizationCheckYou can examine an execution plan for your SQL code to determine whether XQuery optimization occurs … use the optimizer hint NO_XML_QUERY_REWRITE, which turns off XQuery optimization. In addition, you can

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

Oracle XQuery Extension FunctionsOracle XML DB adds some XQuery functions to those provided in the W3C standard. These additional

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

Using Namespaces with XQueryYou can use the XQuery declare namespace declaration in the prolog of an XQuery expression to … illustrates use of a namespace declaration in an XQuery expression. Example 5-13 Using XMLQUERY with a … \" -------------------------------------------------------------------------------- An XQuery namespace declaration

XML DB Developer's Guide, 11g Release 2 (11.2)

Full-Text Search Over XML Data

ora:contains XQuery FunctionXQuery Function Function ora:contains is an Oracle-defined XQuery (XPath) function for use in the … XQuery expression argument to SQL/XML functions XMLQuery, XMLTable, and XMLExists. When you use

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

XQuery Is About SequencesIt is important to keep in mind that XQuery is a general sequence -manipulation language. Its … expressions and their results are not necessarily XML data. An XQuery sequence can contain items of any … XQuery type, which includes numbers, strings, Boolean values, dates, and various types of XML node … --------------------------

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

SQL*Plus XQUERY CommandExample 5-24 shows how you can enter an XQuery expression directly at the SQL*Plus command line, by … preceding the expression with the SQL*Plus command XQUERY and following it with a slash ( / ) on a … line by itself. Oracle Database treats XQuery expressions submitted with this command the same way … it treats XQuery

SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

SET System Variable Summary

SET XQUERY BASEURI {text}file accessed by an XQuery to be changed. To unset the BASEURI, set an empty string, for example: SET … XQUERY BASEURI '' Take care to enter valid values as values are checked only when an XQUERY command … is issued. Example SET XQUERY BASEURI '/public/scott' XQUERY for $i in doc(\"foo.xml\") return

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

Overview of the XQuery LanguageOracle XML DB supports the latest version of the XQuery language specification, W3C XQuery 1.0

XML DB Developer's Guide, 11g Release 2 (11.2)

Using XQuery with Oracle XML DB

Oracle XQuery Extension-Expression PragmasOracle XQuery Extension-Expression P ragmas The W3C XQuery specification lets an implementation … provide implementation-defined extension expressions. An XQuery extension expression is an XQuery … fn:doc or fn:collection. See \"Using Oracle XQuery Pragma ora:defaultTable\". (# ora:invalid_path empty