SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 22

Single Row Functions

Single Row functions are further subdivided into five categories
viz., Character, Data, Numeric, Conversion & other functions.
First we will start with Character Functions or more precisely
“Single Row Character Functions.”

Character Functions:

Following are the functions that fall under this category.

CHR LTRIM INSTR

ASCII RTRIM INSTRB

CONCAT TRIM LENGTH

INITCAP REPLACE LENGTHB

LOWER SOUNDE

X

UPPER SUBSTR

LPAD SUBSTRB

RPAD

Example:

SELECT CHR(67)||CHR(65)||CHR(84) "Pet"
FROM DUAL;

Output:

Pet
---
CAT

Example:

SELECT ASCII('Q')
FROM DUAL;

Output: