Upper Case Text SELECT UPPER('some text') FROM dual; Lower Case Text SELECT LOWER('Some Text') FROM dual;