一点小经验共同分享:
SEQ_bos_t_priv_function为序列,colnum1为主键
insert into table1(colnum1,colnum2) values ('select SEQ_bos_t_priv_function.NEXTVAL from dual', '1');
insert into table1(colnum1,colnum2) values ('select SEQ_bos_t_priv_function.NEXTVAL from dual', '1');
可以直接在数据库中循环添加记录,无需程序做循环!
序列导入导出
1、执行以下sql,SEQUENCE_OWNER = '数据库登陆用户名';
SELECT 'create sequence username.' || SEQUENCE_NAME || ' minvalue ' ||
MIN_VALUE || ' maxvalue ' || MAX_VALUE || ' start with ' ||
LAST_NUMBER || ' increment by ' || INCREMENT_BY || ' cache ' ||
CACHE_SIZE || ' ;'
FROM DBA_SEQUENCES
WHERE SEQUENCE_OWNER = 'DRUG';
2、执行后会查出对应用户的所有序列;是sql
3、不要说了吧, sql直接执行就好了