Tag: case-sensitive

How to do like compare on case sensitive string

select http_host,user_agent,date,path, count(*) FROM “public”.”bus_request” where app_name = ‘yyyy’ and event_type <> ‘browser_js’ and date <= GETDATE() and date>= GETDATE()-14 and …

Case insensitive searching in Oracle

case-insensitive case-sensitive oracle sql sql-like

The default behaviour of LIKE and the other comparison operators, = etc is case-sensitive. Is it possible make them case-insensitive? Answer Since 10gR2, Oracle allows to fine-tune the behaviour of string comparisons by setting the NLS_COMP and NLS_SORT session parameters: You can also create case insensitive indexes: This information was taken from Oracle case insensitive searches. The article mentions REGEXP_LIKE