sql-sequence问题

来源:互联网 发布:java调用adb命令 编辑:程序博客网 时间:2024/06/08 11:19

insert into cucon_j_evaluate_recd 

(cucon_j_evaluate_recdid,description,cucon_j_vendor_evaluateid,cucon_j_venderid,work_code,evaluate_item,evaluate__score,hasld)

select cucon_j_evaluate_recdidseq.nextval,'',81,s.cucon_j_venderid,'905435',s.evaluate_item,'02',0

from cucon_j_evaluate_recd s,dual t

where s.work_code='940070';

原创粉丝点击