Answers for "oracle can you use upper in a in case"

upper and lower in oracle sql

SELECT upper('Hello World') FROM dual;					-- HELLO WORLD
SELECT lower('Hello World') FROM dual;					-- hello world
SELECT inticap('hello world') FROM DUAL; 				-- Hello World

oracle sql uppercase in where clause

SELECT * FROM my_table WHERE upper(MY_COLUMN) = upper('My_String');