Quick Search:


	CODE Oracle PL/SQL Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

The Oracle CONVERT Function [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: CONVERT

Definition:
The Oracle CONVERT function transforms a given string from one character set to another.

Example Syntax:

CONVERT(<string>, <dest_char_set>, <source_char_set>);

The string is the string to be converted.

The dest_char_set parameter is the character set that the string is to be converted to.

The source_char_set parameter is the character set that the string is to be to converted from.

Example Usage:

SELECT CONVERT('Ä Ê Í Ó Ø A B C D E','US7ASCII','WE8ISO8859P1')

FROM DUAL;

The table below lists the available character sets:

Character Set	Description
WE8PC850	IBM PC Code Page 850
US7ASCII	US 7-bit ASCII character set
WE8EBCDIC500	IBM West European EBCDIC Code Page 500
WE8DEC	West European 8-bit character set
WE8HP	HP West European Laserjet 8-bit character set
F7DEC	DEC French 7-bit character set
WE8ISO8859P1	ISO 8859-1 West European 8-bit character set

Related Links:

Oracle Conversion Functions: CONVERT

Related Code Snippets:

Convert Hex to Decimal, Decimal to Hex - Functions to convert Hex to Decimal Example usage: se...
Convert LONGs to LOBs - Converts LONG datatypes to LOBs. You can also use the same procedure to co...
Convert between Decimal, Binary, Octal and Hex - This one will solve a lot of your problems. :) ...
Convert text to soundex - Converts a string of text into separate soundex values. Treating it as ...
CONVERT - Converts a character string from one character set to another. The datatype of the retur...
Converting Rows to Columns - Easy ways to convert rows to columns in Oracle PL/SQL.

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us

PSOUG LOGIN
Username:
Password: