如果您的MAX(noteid)为799,请尝试:
CREATE SEQUENCE noteseq START WITH 800 INCREMENT BY 1
然后,在插入新记录时,对于NOTEID列,您将执行以下操作:
noteseq.nextval

如果您的MAX(noteid)为799,请尝试:
CREATE SEQUENCE noteseq START WITH 800 INCREMENT BY 1
然后,在插入新记录时,对于NOTEID列,您将执行以下操作:
noteseq.nextval