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 -> Re: SQL Command

Re: SQL Command

From: Tanel Poder <tanel_at_@peldik.com>
Date: Mon, 24 Mar 2003 23:01:19 +0200
Message-ID: <3e7f715e$1_2@news.estpak.ee>


> SELECT description
> FROM stock
> WHERE UPPER(description) LIKE '%APPLES%'; or
>
> SELECT description
> FROM stock
> WHERE LOWER(description) LIKE '%apples%';

Note that this kind of query isn't able to use any normal indexes on column description if you don't create function based indexes on UPPER or LOWER function.

Tanel. Received on Mon Mar 24 2003 - 15:01:19 CST

Original text of this message

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