Re: Google like search string to be implemented

Hi,
Yes i know but there are two problems:
1. I am using an earlier version
2. How to make the regex capable for this, i can make in PERL but that great support i think is not available in oracle. Thanks,
Abhishek

On 3/13/07, Ghassan Salem <salem.ghassan_at_gmail.com> wrote:
>
> If you're on 10g, there is the regexp functions that handle regular
> expression manipulation, have a look at them
>
> rgds
>
> On 3/13/07, abhishek jain <mail_at_ejain.com> wrote:
> >
> > Hi Friends,
> > I am having a database with varchar2(255) columns named title,
> > extra_info1,extra_info2,extra_info3 .
> > I want to search all these columns with a search string given to me via
> > a form ,I am using PERL, the string will be like
> >
> > +abhishek jain -abcd "this should be exact"
> > As you can see the word/words prefixed with + should be there somewhere
> > in the above columns in database ,with - should not be there and within ""
> > they should be exact phrase.
> > I want a sol. for this,
> > Pl. help me how to make a search queruy will it be in regex or simople
> > like and not like , i will be having about 1 lac records in the database.
> > I have adequate exp with mysql but not with Oracle , pl. help i need to
> > implement this on Oracle.
> > Thanks,
> > Abhishek jain
> >
>
>

--
http://www.freelists.org/webpage/oracle-l