There are no alternative solutions, unless you drop your requirement to
support 7.3 and 8.0.x. For 8i and above you can use a function in an index
(look up function based indexes in the documentation). You might note that
doing so would leave you supporting all versions of Oracle that are
supported by Oracle themselves.
Your English is a lot better than my German
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Jörg Schneider" <oracle_news.3.joesch_at_spamgourmet.com> wrote in message
news:aq61jl$5mj$1_at_newsreader2.netcologne.de...
> Hello together,
>
> thank you for your solutions but both solutions are no practicable. The
> first one makes the database to big and the second solution ist not
> felexible.
>
> thank you and i am hoping for more ways (what an english ;-))
>
> Jörg Schneider
>
>
> "Laly" <laly.kattoor_at_bnpparibas.com> schrieb im Newsbeitrag
> news:20021030-15813-423147_at_foorum.com...
> >
> > Hi,
> >
> > Otherwise you can try this :
> > if you want to look for names beginning with A :
> > select *
> > from my_table
> > where name like 'A%' or name like 'a%'
> >
> > this will use index on name.
> > You can generalize : looking for names beginning with AA :
> > where name like 'AA%' or name like 'Aa%' or name like 'aA%' or name
like
> 'aa%'
> > ..
> >
> >
> >
> > HTH,
> >
> >
> > Laly.
> >
> >
> > --
> > Use our news server 'news.foorum.com' from anywhere.
> > More details at: http://nnrpinfo.go.foorum.com/
>
>
Received on Mon Nov 04 2002 - 09:03:04 CST
