Create oracle trigger that will update a new column with the concatenated values of the updated columns

I have firstName, lastName and fullName columns in oracle. I want to be able to create a trigger that updates the fullName column with the firstName and lastName values when they are either updated or inserted. I would think this would be possible to do in oracle. Does anyone have any ideas. Thanks very much.

Answers


  create or replace trigger pick_a_name
   before insert or update
   on mytable
   for each row
 begin
    :new.full_name := :new.firstName ||' '|| :new.lastName;
 end pick_a_name;

Need Your Help

MVC Append database record to table after deletion

c# mysql ajax

I have an MVC application that will list names. The names are in an entity framework database. A timer is beside the first name in the list and when the timer ends, the name is removed from the li...

Eclipse Plugin or else for coding footnote

eclipse ide coding-style comments footnotes

I love the Manning In Action Series. One of appealing area is that the code listing inside the book always has a footnote where there is a detailed explanation by a reference number. See below the