Basic SQL

1. By default, Oracle sorts using a binary sort order.
ex:
Russell
SMITH
Sarchand
Sciarra

alter session set NLS_SORT='BINARY_CI'
The above statement would be able to enforce case insensitivity when sorting

2. alter session set NLS_COMP='LINGUISTIC';
This statement would enable Oracle's linguistic comparison capability which enforce case insensitivity in the where clause

3. Use ROLLUP and CUBE functions to aggregate data at multiple levels