Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. INITCAP() returns the character string passed into it with the first letter of each word capitalized
SQL>
Syntax: INITCAP()
SQL>
SQL> SELECT INITCAP('hello world') "HELLO"
  2  FROM dual;
HELLO
-----------
Hello World
SQL>