do an upper on the first name.
>From: Dennis Taylor <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: function index concepts - urgh
>Date: Mon, 12 Mar 2001 07:31:20 -0800
>
>At 11:25 AM
Remember that you need the parameter query_rewrite_enabled=TRUE for those
indexes.
Regards.
> -Mensaje original-
> De: Diana Duncan [SMTP:[EMAIL PROTECTED]]
> Enviado el: lunes 12 de marzo de 2001 16:55
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE:
At 11:25 AM 3/10/01 -0800, you wrote:
>
>This should do it.
>
>select * from holder
>where last_name = upper('Taylor')
>and first_name = upper('Dennis');
Hm. Intuitively then, I should change my index creation script from
(UPPER(LAST_NAME||' '||FIRST_NAME))
to
(UPPER(LAST_NAME)||' '||UPPER(F
In no way would I ever disagree with Jared ;-), but wouldn't it be better to
create two indices rather than the one?
create index HOLDER_LASTNAME_IDX on HOLDER (UPPER(LAST_NAME));
create index HOLDER_FIRSTNAME_IDX on HOLDER (UPPER(FIRST_NAME));
The select statement Jared wrote would definitely w
Dennis,
This should do it.
select * from holder
where last_name = upper('Taylor')
and first_name = upper('Dennis');
And no it's not Friday, it is now Saturday. ;)
Jared
On Fri, 9 Mar 2001, Dennis Taylor wrote:
> create index HOLDER_NAME_IDX on HOLDER (UPPER(LAST_NAME||' '||FIRST_NAME));
