XMLCAST

SQLRF51997Syntax

Description of the illustration xmlcast.gif

SQLRF51998Purpose

XMLCast casts value_expression to the scalar SQL data type specified by datatype. The value_expression argument is a SQL expression that is evaluated. The datatype argument can be of data type NUMBER, VARCHAR2, CHAR, CLOB, BLOB, REF XMLTYPE, and any of the datetime data types.

See Also:

Oracle XML DB Developer's Guide for more information on uses for this function and examples

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® Database SQL Language Reference 11g Release 2 (11.2)
Introduction to Oracle SQL
Pseudocolumns
Basic Elements of Oracle SQL
Operators
Functions
Expressions
Conditions
Common SQL DDL Clauses
SQL Queries and Subqueries
SQL Statements: ALTER CLUSTER to ALTER JAVA
SQL Statements: ALTER LIBRARY to ALTER SYSTEM
SQL Statements: ALTER TABLE to ALTER TABLESPACE
SQL Statements: ALTER TRIGGER to COMMIT
SQL Statements: CREATE CLUSTER to CREATE JAVA
SQL Statements: CREATE LIBRARY to CREATE SPFILE
SQL Statements: CREATE SYNONYM to CREATE TRIGGER
SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT
SQL Statements: DROP SEQUENCE to ROLLBACK
SQL Statements: SAVEPOINT to UPDATE
How to Read Syntax Diagrams
Automatic and Manual Locking Mechanisms During SQL Operations
Oracle and Standard SQL
Oracle Regular Expression Support
Oracle SQL Reserved Words and Keywords
Extended Examples

New and changed documents:

HTML

PDF