can we ignore the case-sensitivity
Suppose my table has a column of varchar datatype and I have inserted data in uppercase or lowercase or in mixed case.
If I want to fire select query then I'll have to take care of the case.Is there any way so that we can ignore the case sensitivity of the database and we can fire select queries without considering case of the data?
In other words,
Is there is any option available in Oracle to bypass case sensitive configuration while retrieving output from oracle query. Oracle does not return output if data in table are in capital letters and query to retrieve data contains value in title case or lower case.An option to deal with such case is to use upper function in oracle query however would be more interested in knowing if there is any option available in oracle to bypass the case sensitive check while retrieving output from query, as it works with SQL.