Answers for "oracle sql uppercase in where clause"

oracle sql query to make column data uppercase

UPDATE
  MyTable
SET
  MyColumn = UPPER(MyColumn)

Posted by: Guest on October-27-2020

oracle sql query to make column data uppercase

SELECT upper('Hello World');		-- HELLO WORLD
SELECT lower('Hello World');		-- hello world

Posted by: Guest on May-06-2021

oracle sql uppercase in where clause

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

Posted by: Guest on January-31-2021

Code answers related to "oracle sql uppercase in where clause"