case insensitive search in oracle sql code example

Example: oracle sql select case insensitive

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