![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
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