oracle case insensitive search code example

Example: oracle sql select case insensitive

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