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 XMLType


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


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

Datatypes

XMLTypeThis Oracle-supplied type can be used to store and query XML data in the database. XMLType has … is another standard developed by the W3C committee to traverse XML documents. Oracle XMLType … packages to create XMLType values from existing relational or object-relational data. XMLType is a system … column. You

Database Concepts, 11g Release 1 (11.1)

Oracle Data Types

XMLType DatatypeXMLTy pe Datatype XMLType can be used like any other user-defined type. XMLType can be used as the … datatype of columns in tables and views. Variables of XMLType can be used in PL/SQL stored … procedures as parameters, return values, and so on. You can also use XMLType in PL/SQL, SQL and Java, and … of these

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

XMLTYPEXMLType constructor. The options are described in the following table. Syntax Description … constructor function XMLType(    xmlData IN clob,    schema IN varchar2:= NULL,    validated IN number:= 0 … creates an optionally schema-based XMLType instance using the specified schema and xml data parameters … . constructor function

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

EXTRACTMember function. Extracts an XMLType fragment and returns an XMLType instance containing the result … XMLType deterministic; Given an XPath expression, applies the XPath to the document and returns the … fragment as an XMLType. MEMBER FUNCTION extract(    xpath IN varchar2,    nsmap IN varchar2) RETURN … XMLType

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

GETNAMESPACEMember function. Returns the namespace of the top level element in the instance. Returns NULL if the input is a fragment or is a non-schema based instance. Syntax MEMBER FUNCTION getNamespace return varchar2 deterministic;

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

GETROOTELEMENTMember function. Gets the root element of the XMLType instance. Returns NULL if the instance is a

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

TOOBJECTinside Oracle XML DB Developer's Guide Syntax MEMBER PROCEDURE toObject( SELF in XMLType, object … . The mapping of the XMLType instance to the converted object instance may be specified using a

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

ISSCHEMAVALIDis schema based, the conformance is checked against the XMLType instance's own schema. Syntax

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

239 XMLTYPEXMLType is a system-defined opaque type for handling XML data. It as predefined member functions on … it to extract XML nodes and fragments. You can create columns of XMLType and insert XML documents … into it. You can also generate XML documents as XMLType instances dynamically using the SYS_XMLGEN … and SYS_XMLAGG SQL functions.

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

CREATESCHEMABASEDXMLMember function. Creates a schema based XMLType instance from a non-schema based XMLType value. It … FUNCTION createSchemaBasedXML( schema IN varchar2:= NULL) return XMLType deterministic; Parameter

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

CREATEXMLStatic function for creating and returning an XMLType instance. The string and clob parameters used … XMLType deterministic; Creates the XMLType instance from a string. STATIC FUNCTION createXML … (    xmlData IN clob) RETURN XMLType deterministic; Creates the XMLType instance from a CLOB. STATIC FUNCTION

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

GETBLOBVALMember function. Returns a BLOB containing the serialized XML representation; if the returns is a temporary BLOB, then it must be freed after use. Syntax MEMBER FUNCTION getBlobVal() RETURN Blob deterministic;

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

GETCLOBVALMember function. Returns a CLOB containing the serialized XML representation; if the returns is a temporary CLOB, then it must be freed after use. Syntax MEMBER FUNCTION getClobVal() RETURN clob deterministic;

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

GETSTRINGVALMember function. Returns the document as a string. Returns s string containing the seralized XML representation, or in case of text nodes, the text itself. If the XML document is bigger than the maximum size of the VARCHAR2, which is 4000, then an error is raised at run time. Syntax MEMBER FUNCTION getStringVal() RETURN varchar2 deterministic;

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

ISFRAGMENTDetermines if the XMLType instance corresponds to a well-formed document, or a fragment. Returns 1 … or 0 indicating if the XMLType instance contains a fragment or a well-formed document. Syntax MEMBER FUNCTION isFragment() RETURN number deterministic;

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

CREATENONSCHEMABASEDXMLMEMBER FUNCTION CREATENONSCHEMABASEDXML return XMLType deterministic;

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

ISSCHEMAVALIDATEDMember function. Returns the validation status of the XMLType instance -- tells if a schema based

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

GETNUMBERVALMember function. Returns a numeric value, formatted from the text value pointed to by the XMLType … instance. The XMLType must point to a valid text node that contains a numerical value. The options

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

TRANSFORMthe parammap is NULL, then a NULL is returned. Syntax MEMBER FUNCTION transform( xsl IN XMLType … , parammap in varchar2:= NULL) RETURN XMLType deterministic; Parameter IN / OUT Description xsl (IN

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

Summary of XMLType SubprogramsTable 239-1 summarizes functions and procedures of the XMLType. Table 239-1 XMLTYPE Subprograms … instance. CREATESCHEMABASEDXML Creates a schema based XMLType instance from the non-schema based … instance using the input schema URL. CREATEXML Static function for creating and returning an XMLType … instance. EXISTSNODE