I have the need to create a sequence that when nextval is requested, the current year is prefix to the number. I also need to figure out a way to restart the sequence when the next year starts, but ...