描述:run.bat:
sqlpuls admin/admin@server001 @task001.sql
task001.sql:insert into user(id,name,order) values('10001','zhangsan',order_start + 1);
insert into admin(id,name,order) values('20002','admin1',order_start - 100);
....我想在task001.sql里面定义一个order_start变量,为其赋值为序列DGK_ORDE.nextval,让以后的SQL可以使用该值,该怎么写?
sqlpuls admin/admin@server001 @task001.sql
task001.sql:insert into user(id,name,order) values('10001','zhangsan',order_start + 1);
insert into admin(id,name,order) values('20002','admin1',order_start - 100);
....我想在task001.sql里面定义一个order_start变量,为其赋值为序列DGK_ORDE.nextval,让以后的SQL可以使用该值,该怎么写?
order_start := select DGK_ORDE.nextval from dual;
.....
end;
select DGK_ORDE.nextval into :order_start from dual;
end;
/insert into user(id,name,order) values('10001','zhangsan',:order_start + 1);
insert into admin(id,name,order) values('20002','admin1',:order_start - 100);
... ...