Trigger tables

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Wed, 15 Jun 2005 18:55:21 -0700 (PDT)
Message-ID: <20050616015521.76522.qmail@web52903.mail.yahoo.com>

Hi,

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.

Example :

Declare
...
..
Begin
--in trigger body.

trigger.tablename

end if;

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

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

Regards,
JKean

---

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 Received on Wed Jun 15 2005 - 22:00:31 CDT