--建表
create table t1(id number,name varchar2(20));
--建序列
create sequence seq_1
increment by 1
start with 10
maxvalue 999999
nocycle
cache;
--先插一条数据
insert into t1 values(1,'A');
试图让id/name都自动产生
于是尝试
insert into t1
select seq_1.nextval,chr(ascii(max(name))+1) from t1;
自然是要报:ORA-02287: sequence number not allowed here
如何才能实现一边id增长,一边name值变化增长呢???
阅读(440) | 评论(0) | 转发(0) |