ASCII

The ASCII function returns the decimal representation of the first character of an expression.

Return Value

INTEGER

Syntax

ASCII (text-exp)

Parameters

text-exp: A text expression.

Usage Notes

OLADM1517Returning EBCDIC Values

When your database character set is 7-bit ASCII, then this function returns an ASCII value. When your database character set is EBCDIC Code, then this function returns an EBCDIC value. There is no corresponding EBCDIC character function

Examples

OLADM1518 Example 7-24 Finding the ASCII Decimal Equivalent of a Character

The following example returns the ASCII decimal equivalent of the letter "Q".

SHOW ASCII('Q') 
81

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® OLAP DML Reference 11g Release 2 (11.2)
OLAP DML Basic Concepts
Data Types, Operators, and Expressions
Formulas, Models, Aggregations, and Allocations
OLAP DML Properties
OLAP DML Options
OLAP DML Programs
OLAP DML Functions: A - K
OLAP DML Functions: L - Z
OLAP DML Commands: A-G
OLAP DML Commands: H-Z
OLAP_TABLE SQL Functions
DBMS_AW PL/SQL Package
OLAP_API_SESSION_INIT

New and changed documents:

HTML

PDF