Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Google like search string to be implemented

Re: Google like search string to be implemented

From: abhishek jain <mail_at_ejain.com>
Date: Tue, 13 Mar 2007 20:26:16 +0530
Message-ID: <dc93054b0703130756p7ccde771v77e9d81394959b05@mail.gmail.com>


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
Received on Tue Mar 13 2007 - 09:56:16 CDT

Original text of this message

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