Some times performing case insensitive search through connection pool(alter session set NLS_SORT=BINARY_CI, alter session set NLS_COMP=LINGUISTIC) is not a feasible way.
Suppose in some report, user wants to have case sensitive search/filter, in this situation above solution is not feasible.
In those cases following method will be useful.
Make a filter using advanced sql option with reference column as uppercase column and also presentation variable.
In detail,
1).Create prompt assign default value as %%(to display each and every row) and also assign a variable to this.
2) Create report, in the report create a filter using advanced – Convert this filter to SQL option, now in this edit box make reference column as upper case and also variable.
In this way we can achieve case insensitive search problem.
Posts
