• 67
    0

    Performing Case-Insensitive Queries in Oracle ProblemYou have loaded a significant amount of data that is in mixed case. You want to query as if it were alllowercase (or all uppercase).Solution  If you are using Oracle Database 10g or higher, you can use the ALTER SESSION statement to enablecase-insensitive searching with the >, <, and = ...