Re: Writting Trigger
From: KonradWo <konrad_at_somewhere.pl>
Date: Wed, 30 Nov 2011 13:38:29 +0100
Message-ID: <4ed623d9$0$8441$65785112_at_news.neostrada.pl>
W dniu 2011-11-30 11:07, "Álvaro G. Vicario" pisze:
KonradWo Received on Wed Nov 30 2011 - 06:38:29 CST
Date: Wed, 30 Nov 2011 13:38:29 +0100
Message-ID: <4ed623d9$0$8441$65785112_at_news.neostrada.pl>
W dniu 2011-11-30 11:07, "Álvaro G. Vicario" pisze:
> Your sample code looks fairly similar to the more obvious and less
> convoluted single query:
>
> UPDATE TAB1
> SET ID2 = 'TEXT' || ID
> WHERE ID=1
>
> ... even this:
>
> UPDATE TAB1
> SET ID2 = 'TEXT1'
> WHERE ID=1
>
> Other than that, I'm not sure I understand your requirements. Do you
> want to write a trigger so every time you update one row all other rows
> will receive the same update? Why do you think you need that? What do
> you have so far?
>
>
>
Thank You
I find the solution in Oracle documentation
Regards
KonradWo Received on Wed Nov 30 2011 - 06:38:29 CST