Re: Trigger - Table Name - Generalise!

I would try a script which generates a script which contains the trigger generation code. The ordering of the lines in the result script you can achieve by using a column named xxxx with noprint column format and ordering by that column.

Martin

Nandakumar wrote:
>
> Hi
>
> There are few tables with identical table structure. And an INSERT
> TRIGGER needs to be attached with each of these tables at ROW LEVEL.
> The trigger checks that if the current insert caues a duplicate, updates
> one of the fields in the old record.
>
> ... so the logic inside the trigger is same except for the table name.
> Is there a way to pass the table name or reference the table name inside
> body of trigger, so that i can write one TRIIGER and attach it with all
> tables!!
>
> Thanks!
>
> --
> Nandakumar
> (N.Kumar_at_rocketmail.com)
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Sep 05 1999 - 04:30:12 CDT