Re: Trigger tables

From: david wendelken <davewendelken_at_earthlink.net>
Date: Thu, 16 Jun 2005 06:21:59 -0400 (EDT)
Message-ID: <1856272.1118917319616.JavaMail.root@wamui-rustique.atl.sa.earthlink.net>

This missed the point.

Unless there's a new feature in 10g, I don't think it can be done.

-----Original Message-----
From: Sony Kristanto <zettira_at_lycos.com> Sent: Jun 16, 2005 3:16 AM
To: jacintakean_at_yahoo.com, oracle-l_at_freelists.org Subject: Re: Trigger tables

Hi Jkean,

Pls try the following syntax,

Select table_name from dba_triggers where trigger_name =3D ... (your trigge= r name).

HTH, Sony

• Original Message ----- From: "Kean Jacinta" <jacintakean_at_yahoo.com> To: oracle-l_at_freelists.org Subject: Trigger tables Date: Wed, 15 Jun 2005 18:55:21 -0700 (PDT)

>=20

> Hi,

>=20

> I got stuck with a problem here. I am trying to create
> a generic trigger.Is there way to find out the
> tablename of the trigger.

>=20

> Example :

>=20

> Declare
> ...
> ..
> Begin
> --in trigger body.
> trigger.tablename

>=20

> end if;

>=20

> *NOTE : wanted to find out the tablename of this
> trigger in trigger body.

>=20
>=20

> Any help, is very much appreciated. Thank in Advance.

>=20

> Regards,
> JKean

>=20
>=20
>=20


> __________________________________________________

> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l

--=20

---

NEW! Lycos Dating Search. The only place to search multiple dating sites at=  once.
http://datingsearch.lycos.com

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

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

Received on Thu Jun 16 2005 - 06:27:06 CDT