Re: Trigger tables

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 16 Jun 2005 12:55:09 +0000
Message-Id: <1118926509l.4701l.0l@medo.noip.com>

On 06/16/2005 03:16:03 AM, Sony Kristanto wrote:
> Hi Jkean,

>=20

> Pls try the following syntax,

>=20
> Select table_name from dba_triggers where trigger_name =3D3D ... (your tr=
igge=3D
> r name).

You should also restrict by owner. Of course, pre-requisite for such thing is the ability to select from dba_triggers. The user_triggers seem like a much better idea. As I've said before, whoever attempts such applica= tion=20
design should change careers and start flipping burgers or become a Wal-Mar= t=20
"associate" (what in the world has happened to shop assistants?). --=20
Mladen Gogala
Oracle DBA

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

Received on Thu Jun 16 2005 - 09:00:22 CDT