Description: CAST converts one built-in datatype or collection-typed value into another built-in datatype or collection-typed value.
You can cast an unnamed operand (such as a date or the result set of a subquery) or a named collection (such as a varray or a nested table) into a type-compatible datatype or named collection. The type_name must be the name of a built-in datatype or collection type and the operand must be a built-in datatype or must evaluate to a collection value.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
CAST(<string_or_column>AS<DATATYPE>)-- The following examples use the CAST function -- with scalar datatypes:SELECTCAST('22-OCT-1997'ASTIMESTAMPWITH LOCAL TIMEZONE)FROM dual;SELECT product_id,CAST(ad_sourcetext ASVARCHAR2(30))FROM print_media;-- This example casts a subquery:SELECT s.custno, s.name,CAST(MULTISET(SELECT ca.street_address,
ca.postal_code,
ca.city,
ca.state_province,
ca.country_id
FROM cust_address ca
WHERE s.custno = ca.custno)AS address_book_t)FROM cust_short s;
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.