Re: Trigger tables
- From: "Sony Kristanto" <zettira@xxxxxxxxx>
- To: jacintakean@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 16 Jun 2005 13:16:03 +0600
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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
> --
> //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
