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

Home -> Community -> Usenet -> c.d.o.server -> Re: Query Cache

Re: Query Cache

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Wed, 20 Nov 2002 18:26:17 -0000
Message-ID: <ftQC9.30061$zX3.72700@news.indigo.ie>


rename the existing table create a replacement view and bung in your fiddle into the viewdef.

Owww ! Stop hitting me ! ;=)
"Stefan" <s.prochazka_at_artaker.com> wrote in message news:abd291f3.0211200649.50865831_at_posting.google.com...
> I have an application which is communication via ODBC with an Oracle
> Database.
> This Application sends queries to the Database and processes the
> result(s).
> I have no access to the source code of this application.
> Is it possible to tell Oracle to modify incoming SQL - Queries and to
> return the modified result?
> For Example
> The Application sends:
> "Select * From x where A = 5"
> This should be modified to
> "Select * From x where A = 6"
> and the result should be taken from the second query.
>
>
> Any help would be appreciated...
>
> THXs,
>
> Stefan
Received on Wed Nov 20 2002 - 12:26:17 CST

Original text of this message

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