Re: Help with Cursor Update/delete/insert

By the way :

> where
> UPPER(mc.lastname)(+) = UPPER(gc.last_name) and
> UPPER(mc.firstname)(+) = UPPER(gc.first_name) and
> UPPER(mc.number_)(+) = UPPER(gc.extsn) ;
>

 will disregard any indexes because of UPPER function,  so think about storing upper values in your DB or

1. For Oracle 7.x, 8.0 - add column, store there the uppercase value and use that column in WHERE
2. For Oracle 8i - create FUNCTION-BASED index on lastname, firstname columns.

 If mc.number_ and gc.extsn are numbers - why do you need  UPPER for them.

 Michael.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 20 1999 - 05:20:51 CDT