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 CAST


1 to 20 of 175 results. Previous page Prev  Next next page
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

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)

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

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.