0 Replies Latest reply on Mar 28, 2016 11:01 PM by 924694

    Oracle LOV search - Case Insensitive

    924694

      Hi

       

      Please help me with below scenario:

       

      I defined a LOV with values  'Abc' and 'Xyz'

       

      I attached this LOV to a field in a Oracle Form (not OAF page/ its standard Java AppLet Oracle Form)

       

      usually all LOV's are case sensitive search i.e. LOV Value 'Abc' pops up only if I search 'Ab%' or 'A%' or '%A%' etc. and doesnt work if I search with 'ab%' or '%a%' etc.

       

      I want to remove this limitation i.e. want to make it  Case Insensitive search - pl guide.

       

      Thanks