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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to capture SQL_TEXT of queries?

Re: How to capture SQL_TEXT of queries?

From: Michael Ho <infoage_at_hk.super.net>
Date: 1997/04/07
Message-ID: <3349161D.E85@hk.super.net>#1/1

Dragon Fly wrote:

> how about setting up a trigger on some system table which gets
> updated or inserted into whenever someone runs "SELECT" ??
> which table(s) might be a good candidate?

Maybe work, never try.
But sounds too risky. I think a good DBA will never allow something like that happen. Received on Mon Apr 07 1997 - 00:00:00 CDT

Original text of this message

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