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
Received on Thu Jun 16 2005 - 03:21:10 CDT