CREATE SEQUENCE subject_id_seq
INCREMENT BY 1
START WITH 101
NO CACHE;

CREATE or REPLACE FUNCTION next_sub_id RETURN VARCHAR2
AS
BEGIN
RETURN(‘FIT’ || TO_CHAR(subject_id_seq.NEXTVAL, ‘FM09999999’));
END;