Re: HELP: Clever SQL Needed

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 02 Sep 1999 18:58:17 +0800
Message-ID: <37CE5849.361D@yahoo.com>

Chris Forlano wrote:
>
> Hi,
>
> I'm trying to create a trigger that detects a query for a specific
> column on a table like this:
>
> select * from <table> where <column1> = '<value>' and <column2> =
> '<value>'
>
> and changes it into something like this:
>
> select * from <table> where <column1> like '%<value>%' and <column2>
> = '<value>'
>
> Essentially, I'm trying to workaround the limitations of a 3rd party
> tool.
>
> Please help.
>
> Chris
>
> --
> Chris Forlano
> TMS Project Manager
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com

You can't trap SELECT's as such

You could have a look at query rewrite in 8i although I don't think its really designed for this purpose..

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Sep 02 1999 - 05:58:17 CDT