CODE EXAMPLE FOR SQL

oracle like case insensitive

select * from my_table where lower(column_1) LIKE lower('my_string')