Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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>