Question

Oracle sql语句插入怎么写

insert into tonglu.tb_putoutconfirm(transfer_type,package_num,handledby,username,tms_service_code,batch,weight)values(?,?,?,?,?,?,?)；
其中batch字段从select tonglu.batch_seq.nextval from dual获得改如何写这条插入语句？

Answer 1

insert into tonglu.tb_putoutconfirm(transfer_type,package_num,handledby,username,tms_service_code,batch,weight)values(?,?,?,?,?,tonglu.batch_seq.nextval,?);

 

 

按位置对应一下，batch在段在倒数第二位，所以那个地方直接引用序列

其他你该怎么传参数还怎么传参数

Answer 2

insert into tonglu.tb_putoutconfirm(transfer_type,package_num,handledby,username,tms_service_code,batch,weight)values(?,?,?,?,?,tonglu.batch_seq.nextval,?);
如果某个字段的值是由序列生成的，则插入时直接使用序列名.nextval即可；

Answer 3

tonglu.batch_seq.nextval 是seq把
insert into tonglu.tb_putoutconfirm(transfer_type,package_num,handledby,username,tms_service_code,batch,weight)values(?,?,?,?,?,tonglu.batch_seq.nextval ,?)；

Answer 4

insert into 表(字段...)values(值...)