Re: Google like search string to be implemented

  • From: "abhishek jain" <mail@xxxxxxxxx>
  • To: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
  • Date: Tue, 13 Mar 2007 20:26:16 +0530

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2007