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: hrishy <hrishys_at_yahoo.co.uk>
Date: Wed, 14 Mar 2007 11:03:28 +0000 (GMT)
Message-ID: <470581.75510.qm@web86910.mail.ukl.yahoo.com>


Hi

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3723269461014

regards
Hrishy
--- abhishek jain <mail_at_ejain.com> wrote:

> 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
> > >
> >
> >
>
                                  



New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes. http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 14 2007 - 06:03:28 CDT

Original text of this message

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