create a before insert trigger, supply the :NEW as 'character '||sequence.nextval