Answers for "oracle sql lowercase"

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 lowercase

SELECT lower('AbBc') FROM DUAL;     -- abbc

oracle lower in where clause

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