Basic trigger question

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 Received on Thu Sep 27 2001 - 09:32:11 CDT