How to Convert the Case of a String

Oracle provides several case related functions as we can see in the following SQL example:

select lower(‘jaMES’) , upper(‘jaMES’), initcap(‘jaMES’) from dual;

lower upper initcap
james JAMES James

IN THIS PAGE