initcap

The initcap function takes a string of characters, changes the first letter of every word to upper case and the remaining letters to lower case:

SQL> select initcap ('andrew reid')
  2  as my_name from dual;

MY_NAME
-----------
Andrew Reid

SQL> select initcap ('ANDREW REID')
  2  as my_name from dual;

MY_NAME
-----------
Andrew Reid

SQL>