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


SQL*Plus User's Guide and Reference, 11g Release 1 (11.1)

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

Database SQL Language Reference, 11g Release 1 (11.1)

Oracle Compliance with SQL/XML:2006

Table B-8 Mapping from XML Schema Built-in Types to SQL Datatypes in XQueryXML Schema Type Oracle SQL Type string VARCHAR2 (4000) decimal NUMBER float BINARY_FLOAT double BINARY_DOUBLE DateTime TIMESTAMP WITH TIME ZONE time TIMESTAMP WITH TIME ZONE date TIMESTAMP WITH TIME ZONE gDay TIMESTAMP WITH TIME ZONE gMonth TIMESTAMP WITH TIME ZONE gYear TIMESTAMP WITH TIME ZONE gYearMonth TIMESTAMP WITH TIME ZONE gMonthDay TIMESTAMP WITH TIME ZONE dayTimeDuration INTERVAL DAY TO

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

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 1 (11.1)

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 1 (11.1)

Using XQuery with Oracle XML DB

ora:replace XQuery FunctionSyntax ora:replace (target_string, match_pattern, replace_string [, match_parameter]) XQuery … matching: case-sensitivity and so on. The behavior of XQuery function ora:matches is the same as … that of SQL function regexp_replace, but the types of its arguments are XQuery types instead of SQL

SQL*Plus User's Guide and Reference, 11g Release 1 (11.1)

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 1 (11.1)

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 1 (11.1)

Using XQuery with Oracle XML DB

ora:matches XQuery FunctionSyntax ora:matches (target_string, match_pattern [, match_parameter]) XQuery function ora:matches … 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 instead of SQL

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

Using XQuery with Oracle XML DB

Performance Tuning for XQueryAs mentioned, Oracle XML DB generally evaluates XQuery expressions by executing equivalent … benefits. Just as query tuning can improve SQL performance, so it can improve XQuery performance … . You tune XQuery performance by choosing appropriate XML storage models and indexes. As with database … addition, be aware that the following

SQL*Plus User's Guide and Reference, 11g Release 1 (11.1)

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 1 (11.1)

Using XQuery with Oracle XML DB

ora:contains XQuery Functionora:contains can be used in an XPath expression inside an XQuery expression or in a call to SQL function … higher the number, the more relevant the match), and zero otherwise. When used in an XQuery … expression, the XQuery return type is xs:integer(). when used in an XPath expression outside of an XQuery

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

Using XQuery with Oracle XML DB

ora:sqrt XQuery FunctionSyntax ora:sqrt (number) XQuery function ora:sqrt returns the square root of its numerical 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.

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

Using XQuery with Oracle XML DB

ora:view XQuery FunctionXQuery function ora:view lets you query existing database tables or views inside an XQuery expression, as

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

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 … XQuery namespace declaration has no effect outside of its XQuery expression. To declare a namespace … prefix for use in an XMLTable expression outside of the XQuery expression, use the XMLNAMESPACES

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

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, as well as various types of XML … applies SQL function XMLQuery

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

Using XQuery with Oracle XML DB

SQL*Plus XQUERY CommandExample 18-21 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

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

Using XQuery with Oracle XML DB

When To Use XQueryYou can use XQuery to do many of the same things that you might do using the SQL/XML generation … that XQuery is often used when the focus is the world of XML data, while the SQL/XML generation … existing XML documents, then it is likely that an XQuery FLOWR expression will be simpler (simplifying

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

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 1 (11.1)

Using XQuery with Oracle XML DB

Using XQuery with XMLType DataThis section presents examples of using XQuery with XMLType relational data. Example 18-8 Using … , oe.warehouse_spec, as context item to XQuery, using function XMLQuery with the PASSING clause. It … 80,000. return constructs an XQuery sequence of Details elements, each of which contains a Docks … match the XQuery

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

Using XQuery with Oracle XML DB

Support for XQuery and SQLSupport for the XQuery language in Oracle XML DB is designed to provide the best fit between the … worlds of relational storage and querying XML data. That is, Oracle XML DB is a general XQuery … implementation, but it is in addition specifically designed to make relational and XQuery queries work well … together. The specific