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@xxxxxxxxx> Sent: Jun 16, 2005 3:16 AM To: jacintakean@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx 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@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 -- //www.freelists.org/webpage/oracle-l