Description: Converts NCHAR, NVARCHAR2, CLOB, or NCLOB data to the database character set. The value returned is always VARCHAR2.
When you use this function to convert a character LOB into the database character set, if the LOB value to be converted is larger than the target type, then the database returns an error.
You can use this function in conjunction with any of the XML functions to generate a date in the database format rather than the XML Schema standard format.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
TO_CHAR(<string_or_column>,<format>)RETURNVARCHAR2-- The following example interprets a simple string as -- character data:SELECTTO_CHAR('01110')FROM DUAL;
TO_CH
-----
01110
-- This example converts some CLOB data to the database -- character set:SELECTTO_CHAR(ad_sourcetext)FROM print_media
WHERE product_id =2268;TO_CHAR(AD_SOURCETEXT)-- Convert NUMBER to HEX:TO_CHAR(NUMBER)RETURN HEX
-- Convert NUMBER to CHARACTER:SELECTTO_CHAR(123)FROM dual;-- An example from Tom Kyte showing formatting: SELECTTO_CHAR(dt,'HH:MI AM') A,TO_CHAR(dt,'FMHH:MI AM') B,TO_CHAR(dt,'FMHHFM:MI AM') C
FROM(SELECTTO_DATE('09:01 am','HH:MI AM') dt FROM dual);
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.
