Re: Google like search string to be implemented

I did something like that 7 years ago. If you are serious about building google like search syntax, you need to build your own parser. I used JavaCC (Java compiler compiler) to define the grammer and dynamically buile the SQL where clause out of the parse tree.

Regards

Richard Ji

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

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