Re: TRIGGER-Name of the current table

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 5 Oct 2006 02:56:37 -0700
Message-ID: <1160042197.885610.40990@c28g2000cwb.googlegroups.com>

Taras wrote:
> Hello,
>
> I'm fairly new at PL-SQL, so forgive mi if this question sounds
> stupid...
>
> I'm trying to write a trigger on a certain table. Is it possible to
> retrieve the name of that table within the code of it's trigger?
>
> My goal is to write a code for universal trigger (it would do the same
> thing on all tables). That trigger would call a procedure and pass the
> name of it's parent table as a parameter.
>

Maybe this is a good starting point for further searches: http://forums.oracle.com/forums/message.jspa?messageID=512084

What would your "universal" trigger do?

cheers,
Martin Received on Thu Oct 05 2006 - 04:56:37 CDT