INITCAP() returns the character string passed into it with the first letter of each word capitalized
SQL> Syntax: INITCAP(<character_string>) SQL> SQL> SELECT INITCAP('hello world') "HELLO" 2 FROM dual; HELLO ----------- Hello World SQL>