How does one write a trigger in PL/SQL to :
get source data such as "turner,vincent", "224 Argonne blvd", "New Orleans,
LA 70150", "504-532-2285 " to be transformed to:

LastName: Vincent FirstName: Turner Street: 224 Argonne blvd
City: New Orleans State: LA Zip: 70150 Phone: 504-532-2285

The trigger is to be written on the insert of Table A(with fields Name, Street,
Address, Phone) to load data into table B(with fields First Name,Last Name,Street,
City, State, Zip,Phone,Date, User).The date is the sysdate and user is the
current username in Oracle. How does one get both the user, date in the trigger?

Thanks.