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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Case insensitive query in SQLPlus?

Re: Case insensitive query in SQLPlus?

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Fri, 03 Aug 2001 14:53:01 GMT
Message-ID: <hVya7.417774$p33.8440380@news1.sttls1.wa.home.com> 






You can make a function based index (upper( theColumn)) and then it will be
much faster than doing upper on both sides of the where clause.
Jim


"Stan Brown" <stanb_at_panix.com> wrote in message
news:9kebvu$gp2$1_at_panix6.panix.com...


> I need to be able to prepare queries (from a perl script) that will make

> case insensitive searchs on VARCAHR2 columns.

>

> This must be common, but I'm drawing a blank.

>

> Can anyone help me out here?

>

>

Received on Fri Aug 03 2001 - 09:53:01 CDT












Original text of this message













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