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

    Oracle LOV search - Case Insensitive




      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.