Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

LOWER ( ) converts every letter in a string to lower case,

UPPER ( ) converts every letter in a string to upper case,

INITCAP ( ) Initial capital, Capitalize the first letter of a word or series of word,

11.10   How to use upper ( )

function

11.11   How to use lower ( )

function

11.12   How to use Initial ( )

function

Options like column-name may be given within parenthesis or the letters 1  string embedded by single quotes will give desired result, For example

SYNTAX:    select   upper   (ledger-name)   "UPPER", InitCap (ledger-name) "Init Cap",

lower ('ORACLE APEX') from raak-ledger-master; RESULT:

UPPER                     INIT CAP                 LOWER