How to Ignore case sensitive in Oracle Database when you fetching records?

Oracle Database is case sensitive database if you fetch any data with WHERE clause it should be match case.
To ignore the case sensitive you can use ALTER SESSION statements to set comparison to case-insensitive.

alter session set NLS_COMP=ANSI;
alter session set NLS_SORT=BINARY_CI;