17,377
社区成员
发帖
与我相关
我的任务
分享
create table TEST99
(
LX1 VARCHAR2(10),
VDATE DATE,
MDATE DATE,
TS NUMBER,
HBJE NUMBER,
AMT NUMBER
)
insert into test99 (LX1, VDATE, MDATE, TS, HBJE, AMT)
values ('付息日', to_date('13-03-2014', 'dd-mm-yyyy'), to_date('10-04-2017', 'dd-mm-yyyy'), 1124, 0, 200000000);
insert into test99 (LX1, VDATE, MDATE, TS, HBJE, AMT)
values ('还本日', to_date('10-04-2017', 'dd-mm-yyyy'), to_date('29-04-2017', 'dd-mm-yyyy'), 19, 100000000, 200000000);
insert into test99 (LX1, VDATE, MDATE, TS, HBJE, AMT)
values ('还本日', to_date('29-04-2017', 'dd-mm-yyyy'), to_date('26-05-2017', 'dd-mm-yyyy'), 27, 50000000, 100000000);
insert into test99 (LX1, VDATE, MDATE, TS, HBJE, AMT)
values ('付息日', to_date('26-05-2017', 'dd-mm-yyyy'), to_date('10-04-2018', 'dd-mm-yyyy'), 319, 0, 50000000);
insert into test99 (LX1, VDATE, MDATE, TS, HBJE, AMT)
values ('到期日', to_date('10-04-2018', 'dd-mm-yyyy'), to_date('13-03-2019', 'dd-mm-yyyy'), 337, 50000000, 50000000);