Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Searching CLOBS case insensitive

Searching CLOBS case insensitive

From: Petri <Petri33_at_hotmail.com>
Date: 18 Dec 2002 13:12:20 -0800
Message-ID: <b4803f2d.0212181312.2dcc4fde@posting.google.com> 





I am trying to search a CLOB field case insensitively.  I am currently
using dbms_lob.instr() but this function is case sensitive.  Does
anyone know how to search case insensitively?
Received on Wed Dec 18 2002 - 15:12:20 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US