create table CONTRACT_NOTE
(
  CN_NO     VARCHAR2(30) not null,
  MKT_VAL   NUMBER default 0,
  BRK       NUMBER default 0,
  NET_VALUE NUMBER default 0
);
prompt Loading CONTRACT_NOTE...
insert into CONTRACT_NOTE (CN_NO, MKT_VAL, BRK, NET_VALUE)
values ('NN01', 100, 10, 110);
insert into CONTRACT_NOTE (CN_NO, MKT_VAL, BRK, NET_VALUE)
values ('NN01', 200, 20, 220);
insert into CONTRACT_NOTE (CN_NO, MKT_VAL, BRK, NET_VALUE)
values ('NN03', 300, 30, 330);
insert into CONTRACT_NOTE (CN_NO, MKT_VAL, BRK, NET_VALUE)
values ('NN04', 440, 44, 484);
insert into CONTRACT_NOTE (CN_NO, MKT_VAL, BRK, NET_VALUE)
values ('NN05', 548, 54.8, 602.8);
insert into CONTRACT_NOTE (CN_NO, MKT_VAL, BRK, NET_VALUE)
values ('NN06', 445, 44.5, 489.5);
insert into CONTRACT_NOTE (CN_NO, MKT_VAL, BRK, NET_VALUE)
values ('NN06', 458, 45.8, 503.8);
insert into CONTRACT_NOTE (CN_NO, MKT_VAL, BRK, NET_VALUE)
values ('NN06', 784, 78.4, 862.4);
commit;