Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to capture SQL_TEXT of queries?
Dragon Fly wrote:
>
> In short, I need to set up kind of a trigger
> on some of the tables so that it captures the
> text of the queries run against those tables.
> The problem is, the "standard"
> triggers can be set up only for UPDATE OR INSERT
> while I need a trigger for SELECT statement.
> Anybody has an idea what is the good way of implementing
> such kind of thing?
Never heard trigger on select. Only heard event tracing, but I don't think it is something you want. Received on Sun Apr 06 1997 - 00:00:00 CST
![]() |
![]() |