The Oracle and PL/SQL INITCAP function sets the first character in each word to uppercase and the rest to lowercase.
The general format is:
INITCAP(char)
Example 1:
SELECT INITCAP('john williams') FROM DUAL;
returns:
John Williams
The Oracle and PL/SQL INITCAP function sets the first character in each word to uppercase and the rest to lowercase.
The general format is:
INITCAP(char)
Example 1:
SELECT INITCAP('john williams') FROM DUAL;
returns:
John Williams