| Function | Description |
| ASCIISTR(x) | Converts x to an ASCII string, where x may be a string in any character set. |
| BIN_TO_NUM(x) | Converts x to a binary number. Returns a NUMBER. |
| CAST(x AS type_name) | Converts a value in x from one data type to another specified in type_name. |
| CHARTOROWID(x) | Converts x to a ROWID. |
| COMPOSE(x) | Converts x to a Unicode string in its fully normalized form in the same character set as x. Unicode uses a 2-byte character set and can represent over 65,000 characters; it may also be used to represent non-English characters. |
| CONVERT(x, source_char_set, dest_char_set) | Converts x from source_char_set to dest_char_set. |
| DECODE(x, search, result, default) | Compares x with the value in search; if equal, DECODE() returns search, otherwise the value in default is returned. |
| DECOMPOSE(x) | Converts x to a Unicode string after decomposition in the same character set as x. |
| HEXTORAW(x) | Converts the character x containing hexadecimal digits (base 16) to a binary number (RAW). This function returns the returns RAW number. |
| NUMTODSINTERVAL(x) | Converts the number x to an INTERVAL DAY TO SECOND. You'll learn about date and time intervalCrelated functions in the next chapter. |
| NUMTOYMINTERVAL(x) | Convert the number x to an INTERVAL YEAR TO MONTH. |
| RAWTOHEX(x) | Converts the binary number (RAW) x to a VARCHAR2 character containing the equivalent hexadecimal number. |
| RAWTONHEX(x) | Converts the binary number (RAW) x to an NVARCHAR2 character containing the equivalent hexadecimal number. An NVARCHAR2 is used to store strings in the national character set. |
| ROWIDTOCHAR(x) | Converts the ROWID x to a VARCHAR2 character. |
| ROWIDTONCHAR(x) | Converts the ROWID x to an NVARCHAR2 character. |
| TO_BINARY_DOUBLE(x) | New for Oracle Database 10g. Converts x to a BINARY_DOUBLE. |
| TO_BINARY_FLOAT(x) | New for Oracle Database 10g. Converts x to a BINARY_FLOAT. |
| TO_CHAR(x [, format]) | Converts x to a VARCHAR2 string. You can supply an optional format that indicates the format of x. |
| TO_CLOB(x) | Converts x to a character large object (CLOB). A CLOB is used to store large amounts of character data. |
| TO_DATE(x [, format]) | Converts x to a DATE. |
| TO_DSINTERVAL(x) | Convert the string x to an INTERVAL DAY TO SECOND. |
| TO_MULTI_BYTE(x) | Converts the single-byte characters in x to their corresponding multi-byte characters. The return type is the same as the type for x. |
| TO_NCHAR(x) | Converts x in the database character set to an NVARCHAR2. |
| TO_NCLOB(x) | Converts x to an NCLOB. An NCLOB is used to store large amounts of national language character data. |
| TO_NUMBER(x [, format]) | Converts x to a NUMBER. |
| TO_SINGLE_BYTE(x) | Converts the multi-byte characters in x to their corresponding single-byte characters. The return type is the same as the type for x. |
| TO_TIMESTAMP(x) | Converts the string x to a TIMESTAMP. |
| TO_TIMESTAMP_TZ(x) | Converts the string x to a TIMESTAMP WITH TIME ZONE. |
| TO_YMINTERVAL(x) | Converts the string x to an INTERVAL YEAR TO MONTH. |
| TRANSLATE(x, from_string, to_string) | Converts all occurrences of from_string in x to to_string. |
| UNISTR(x) | Converts the characters in x to the national language character set (NCHAR). |
Quote from:
Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)
# Paperback: 608 pages
# Publisher: McGraw-Hill Osborne Media; 1st edition (February 20, 2004)
# Language: English
# ISBN-10: 0072229810
# ISBN-13: 978-0072229813
| 15.1.Introduction | ||||
| 15.1.1. | Conversion Functions | |||