ASCIISTR

Syntax

asciistr::=

Text description of asciistr

Purpose

ASCIISTR takes as its argument a string in any character set and returns an ASCII string in the database character set. The value returned contains only characters that appear in SQL, plus the forward slash (/).

See Also: Oracle9i Globalization Support Guide for information on unicode character sets and character semantics

Example

The following example returns the ASCII string equivalent of the text string "flauwekul":

SELECT ASCIISTR('flauwekul') FROM DUAL;

ASCIISTR('FLAUW
---------------
\6<65\756<\6700