Re: Basic trigger question

"J.Patrick" <pat_at_mindwrap.com> a écrit dans le message news: 73e908ac.0109270632.41131161_at_posting.google.com...
> Can you have a trigger that performs a function on the same table that
> initiates the trigger. For example a trigger created like this:
>
>
> create or replace trigger [trigger name]
> after insert or update on table_abc
> for each row
> begin
> update table_abc set odcomments = concat(column1, column2, column3);
> end;
>
>
> If not... does anyone have any suggestions to do what seems like a simple action?
>
> Thanks very much.
>
>
> Pat

You can use:
:new.odcomments = concat(:new.column1, :new.column2, :new.column3); to update the field of the current row.

If you have to update fields of other rows in the table have a look at Thomas Kyte site, url:
http://osi.oracle.com/~tkyte/Mutate/index.html

--
Have a nice day
Michel