Results for CAST


1 to 20 of 175 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

CAST

from BINARY_FLOAT, BINARY_DOUBLE from CHAR, VARCHAR2 fromNUMBER from DATETIME / INTERVAL Note 1 fromRAW…TIMEZONE, INTERVAL DAY TO SECOND, and INTERVAL YEAR TO MONTH. Note 2: You cannot cast a UROWID to a ROWID … if the UROWID contains the value of a ROWID of an index-organized table. If you want to cast a named … into which they are cast. Without the MULTISET keyword, the subquery is treated as a scalar subquery … . Built-In Datatype

SQL Reference, 10g Release 1 (10.1)

CAST

CASTSyntax cast::= Description of the illustration cast.gif Purpose CAST converts one built-in datatype … or collection-typed value into another built-in datatype or collection-typed value. CAST lets you … collection type. You can cast an unnamed operand (such as a date or the result set of a subquery) or … of an

Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

2 Basic Components of Oracle Objects

CASTcollection-typed value. For example: CREATE TYPE person_list_typ AS TABLE OF person_typ;/ SELECT CAST

Packages and Types Reference, 10g Release 1 (10.1)

173 JMS Types

Cast Methodsaq$_jms_message from an aq$_jms_object_message. Cast Methods

Error Messages, 10g Release 1 (10.1)

57 PCC-02010 to PCC-02451

PCC-02317: illegal cast type expressionexpression to eliminate the non-arithmetic operator. PCC-02317: illegal cast type expression

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00563: illegal use of CAST expressionsure the function is returning a data type. PLS-00563: illegal use of CAST expression

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-102 ┬áMAKENODE Function Parameters Parameter Description a DOMAttr to cast. cds … DOMCDataSection to cast. cd DOMCharacterData to cast. com DOMComment to cast. doc DOMDocument to cast. df … DOMDocumentFragment to cast. dt DOMDocumentType to cast. elem DOMElement

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-22907: invalid CAST to a type that is not a nested table or VARRAYallowed in the DML. ORA-22907: invalid CAST to a type that is not a nested table or VARRAY

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00570: different number of columns in the multiset and cast expressions: Change the value of the literal PLS-00570: different number of columns in the multiset and cast expressions

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-22833: Must cast a transient type to a persistent typestring in multiple passes. ORA-22833: Must cast a transient type to a persistent type

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-99 MAKEELEMENT Function Parameters Parameter Description n DOMNode to cast.

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-105 MAKETEXT Function Parameters Parameter Description n DOMNode to cast

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-98 MAKEDOCUMENTTYPE Function Parameters Parameter Description n DOMNode to cast.

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-100 MAKEENTITY Function Parameters Parameter Description n DOMNode to cast.

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-96 MAKEDOCUMENT Function Parameters Parameter Description n DOMNode to cast.

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-92 MAKEATTR Function Parameters Parameter Description n DOMNode to cast

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-103 MAKENOTATION Function Parameters Parameter Description n DOMNode to cast

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-95 MAKECOMMENT Function Parameters Parameter Description n DOMNode to cast.

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-104 MAKEPROCESSINGINSTRUCTION Function Parameters Parameter Description n DOMNode to cast

Packages and Types Reference, 10g Release 1 (10.1)

113 DBMS_XMLDOM

ParametersTable 113-101 MAKEENTITYREFERENCE Function Parameters Parameter Description n DOMNode to cast.


Was this page helpful?