If I define a computed column like the one in documents:
full_name computed by (first_name || ' ' || last_name)
It works only if non of the two composing columns is null. Otherwise, the
value is null if any of the two is null. Is there any way to make it without
the need to write additional code like the stuff: if (first_name is null)
then full_name = last_name else...
Can a trigger be defined to "trigger" at different events. I mean is there a
way to make the following work:
create trigger my_trigger for my_table
before insert or update as
begin

end

Regards
Omar