Skip Headers
Oracle® OLAP Expression Syntax Reference
Release 11.2

Part Number E23381-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

TRANSLATE (USING)

TRANSLATE converts a text string between the database character set and the national character set.

Note: The TRANSLATE USING function is supported primarily for ANSI compatibility. Oracle recommends that you use the TO_CHAR and TO_NCHAR functions for converting data to the database or national character sets. TO_CHAR and TO_NCHAR can take as arguments a greater variety of data types than TRANSLATE USING, which accepts only character data.

Return Value

VARCHAR2 | NVARCHAR2

Syntax

TRANSLATE (char USING { CHAR_CS | NCHAR_CS } )

Arguments

char is a text expression to be converted to the database character set (USING CHAR_CS) or the national character set (USING NCHAR_CS).

Example

TRANSLATE('north by northwest' USING NCHAR_CS) returns the value north by northwest in the national character set.