oracle多变量批量造测试数据

最新推荐文章于 2024-03-04 10:18:42 发布

佳司海心

最新推荐文章于 2024-03-04 10:18:42 发布

阅读量525

点赞数

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/weixin_45634463/article/details/127744055

版权

方法：
drop sequence C_CUSTNO;
drop sequence C_CSERIALNO;
drop sequence C_FUNDACCO;
drop sequence C_TRADEACCO;
create sequence C_CUSTNO minvalue 900000000000;
create sequence C_CSERIALNO minvalue 9251000000000;
create sequence C_FUNDACCO minvalue 900000000000;
create sequence C_TRADEACCO minvalue 2259000000;
declare x number;
begin x:=0;
loop

insert into tconfirm (C_CUSTNO, C_BUSINFLAG, D_CDATE, C_CSERIALNO, D_REQUESTDATE, D_REQUESTTIME, C_FUNDACCO, C_AGENCYNO, C_NETNO, C_TRADEACCO, C_FUNDCODE, F_CONFIRMBALANCE, F_CONFIRMSHARES, F_TRADEFARE, F_TAFARE, F_STAMPTAX, F_BACKFARE, F_OTHERFARE1, F_BREACHFARE, F_PROFITBALANCE, F_TOTALFARE, F_TRADEFARE4AGT, F_TRADEFARE4FUND, F_TAFARE4AGT, F_TAFARE4FUND, F_BACKFARE4AGT, F_BACKFARE4FUND, F_OTHERFARE14AGT, F_OTHERFARE14FUND, F_BREACHFARE4AGT, F_BREACHFARE4FUND, F_PROFITBALANCE4AGT, F_PROFITBALANCE4FUND, F_INTEREST, F_INTERESTTAX, F_INTERE