Edit D:\app\Administrator\product\11.2.0\dbhome_1\oramts\SAMPLES\sql\omtssamp.sql

Rem ************************************************************
Rem Create the ACCOUNT table for the VB Sample application 
Rem provided with Microsoft Transaction Server
Rem ************************************************************
drop table Account;
create table Account ( 
                       Balance number,
                       AccountNo number
                     ) initrans 100 maxtrans 255;
insert into Account values (1000, 1);
insert into Account values (1000, 2);
insert into Account values (1000, 3);
insert into Account values (1000, 4);
insert into Account values (1000, 5);
insert into account values(1000, 6);
insert into account values(1000, 7);
insert into account values(1000, 8);
insert into account values(1000, 9);
insert into account values(1000, 10);
insert into account values(1000, 11);
insert into account values(1000, 12);
insert into account values(1000, 13);
insert into account values(1000, 14);
insert into account values(1000, 15);
insert into account values(1000, 16);
insert into account values(1000, 17);
insert into account values(1000, 18);
insert into account values(1000, 19);
insert into account values(1000, 20);
insert into account values(1000, 21);
insert into account values(1000, 22);
insert into account values(1000, 23);
insert into account values(1000, 24);
insert into account values(1000, 25);
insert into account values(1000, 26);
insert into account values(1000, 27);
insert into account values(1000, 28);
insert into account values(1000, 29);
insert into account values(1000, 30);
insert into account values(1000, 31);
insert into account values(1000, 32);
insert into account values(1000, 33);
insert into account values(1000, 34);
insert into account values(1000, 35);
insert into account values(1000, 36);
insert into account values(1000, 37);
insert into account values(1000, 38);
insert into account values(1000, 39);
insert into account values(1000, 40);
insert into account values(1000, 41);
insert into account values(1000, 42);
insert into account values(1000, 43);
insert into account values(1000, 44);
insert into account values(1000, 45);
insert into account values(1000, 46);
insert into account values(1000, 47);
insert into account values(1000, 48);
insert into account values(1000, 49);
insert into account values(1000, 50);
insert into account values(1000, 51);
insert into account values(1000, 52);
insert into account values(1000, 53);
insert into account values(1000, 54);
insert into account values(1000, 55);
insert into account values(1000, 56);
insert into account values(1000, 57);
insert into account values(1000, 58);
insert into account values(1000, 59);
insert into account values(1000, 60);
insert into account values(1000, 61);
insert into account values(1000, 62);
insert into account values(1000, 63);
insert into account values(1000, 64);
insert into account values(1000, 65);
insert into account values(1000, 66);
insert into account values(1000, 67);
insert into account values(1000, 68);
insert into account values(1000, 69);
insert into account values(1000, 70);
insert into account values(1000, 71);
insert into account values(1000, 72);
insert into account values(1000, 73);
insert into account values(1000, 74);
insert into account values(1000, 75);
insert into account values(1000, 76);
insert into account values(1000, 77);
insert into account values(1000, 78);
insert into account values(1000, 79);
insert into account values(1000, 80);
insert into account values(1000, 81);
insert into account values(1000, 82);
insert into account values(1000, 83);
insert into account values(1000, 84);
insert into account values(1000, 85);
insert into account values(1000, 86);
insert into account values(1000, 87);
insert into account values(1000, 88);
insert into account values(1000, 89);
insert into account values(1000, 90);
insert into account values(1000, 91);
insert into account values(1000, 92);
insert into account values(1000, 93);
insert into account values(1000, 94);
insert into account values(1000, 95);
insert into account values(1000, 96);
insert into account values(1000, 97);
insert into account values(1000, 98);
insert into account values(1000, 99);
insert into account values(1000, 100);
commit;
insert into account values(1000, 101);
insert into account values(1000, 102);
insert into account values(1000, 103);
insert into account values(1000, 104);
insert into account values(1000, 105);
insert into account values(1000, 106);
insert into account values(1000, 107);
insert into account values(1000, 108);
insert into account values(1000, 109);
insert into account values(1000, 110);
insert into account values(1000, 111);
insert into account values(1000, 112);
insert into account values(1000, 113);
insert into account values(1000, 114);
insert into account values(1000, 115);
insert into account values(1000, 116);
insert into account values(1000, 117);
insert into account values(1000, 118);
insert into account values(1000, 119);
insert into account values(1000, 120);
insert into account values(1000, 121);
insert into account values(1000, 122);
insert into account values(1000, 123);
insert into account values(1000, 124);
insert into account values(1000, 125);
insert into account values(1000, 126);
insert into account values(1000, 127);
insert into account values(1000, 128);
insert into account values(1000, 129);
insert into account values(1000, 130);
insert into account values(1000, 131);
insert into account values(1000, 132);
insert into account values(1000, 133);
insert into account values(1000, 134);
insert into account values(1000, 135);
insert into account values(1000, 136);
insert into account values(1000, 137);
insert into account values(1000, 138);
insert into account values(1000, 139);
insert into account values(1000, 140);
insert into account values(1000, 141);
insert into account values(1000, 142);
insert into account values(1000, 143);
insert into account values(1000, 144);
insert into account values(1000, 145);
insert into account values(1000, 146);
insert into account values(1000, 147);
insert into account values(1000, 148);
insert into account values(1000, 149);
insert into account values(1000, 150);
insert into account values(1000, 151);
insert into account values(1000, 152);
insert into account values(1000, 153);
insert into account values(1000, 154);
insert into account values(1000, 155);
insert into account values(1000, 156);
insert into account values(1000, 157);
insert into account values(1000, 158);
insert into account values(1000, 159);
insert into account values(1000, 160);
insert into account values(1000, 161);
insert into account values(1000, 162);
insert into account values(1000, 163);
insert into account values(1000, 164);
insert into account values(1000, 165);
insert into account values(1000, 166);
insert into account values(1000, 167);
insert into account values(1000, 168);
insert into account values(1000, 169);
insert into account values(1000, 170);
insert into account values(1000, 171);
insert into account values(1000, 172);
insert into account values(1000, 173);
insert into account values(1000, 174);
insert into account values(1000, 175);
insert into account values(1000, 176);
insert into account values(1000, 177);
insert into account values(1000, 178);
insert into account values(1000, 179);
insert into account values(1000, 180);
insert into account values(1000, 181);
insert into account values(1000, 182);
insert into account values(1000, 183);
insert into account values(1000, 184);
insert into account values(1000, 185);
insert into account values(1000, 186);
insert into account values(1000, 187);
insert into account values(1000, 188);
insert into account values(1000, 189);
insert into account values(1000, 190);
insert into account values(1000, 191);
insert into account values(1000, 192);
insert into account values(1000, 193);
insert into account values(1000, 194);
insert into account values(1000, 195);
insert into account values(1000, 196);
insert into account values(1000, 197);
insert into account values(1000, 198);
insert into account values(1000, 199);
insert into account values(1000, 200);
commit;
insert into account values(1000, 201);
insert into account values(1000, 202);
insert into account values(1000, 203);
insert into account values(1000, 204);
insert into account values(1000, 205);
insert into account values(1000, 206);
insert into account values(1000, 207);
insert into account values(1000, 208);
insert into account values(1000, 209);
insert into account values(1000, 210);
insert into account values(1000, 211);
insert into account values(1000, 212);
insert into account values(1000, 213);
insert into account values(1000, 214);
insert into account values(1000, 215);
insert into account values(1000, 216);
insert into account values(1000, 217);
insert into account values(1000, 218);
insert into account values(1000, 219);
insert into account values(1000, 220);
insert into account values(1000, 221);
insert into account values(1000, 222);
insert into account values(1000, 223);
insert into account values(1000, 224);
insert into account values(1000, 225);
insert into account values(1000, 226);
insert into account values(1000, 227);
insert into account values(1000, 228);
insert into account values(1000, 229);
insert into account values(1000, 230);
insert into account values(1000, 231);
insert into account values(1000, 232);
insert into account values(1000, 233);
insert into account values(1000, 234);
insert into account values(1000, 235);
insert into account values(1000, 236);
insert into account values(1000, 237);
insert into account values(1000, 238);
insert into account values(1000, 239);
insert into account values(1000, 240);
insert into account values(1000, 241);
insert into account values(1000, 242);
insert into account values(1000, 243);
insert into account values(1000, 244);
insert into account values(1000, 245);
insert into account values(1000, 246);
insert into account values(1000, 247);
insert into account values(1000, 248);
insert into account values(1000, 249);
insert into account values(1000, 250);
insert into account values(1000, 251);
insert into account values(1000, 252);
insert into account values(1000, 253);
insert into account values(1000, 254);
insert into account values(1000, 255);
insert into account values(1000, 256);
insert into account values(1000, 257);
insert into account values(1000, 258);
insert into account values(1000, 259);
insert into account values(1000, 260);
insert into account values(1000, 261);
insert into account values(1000, 262);
insert into account values(1000, 263);
insert into account values(1000, 264);
insert into account values(1000, 265);
insert into account values(1000, 266);
insert into account values(1000, 267);
insert into account values(1000, 268);
insert into account values(1000, 269);
insert into account values(1000, 270);
insert into account values(1000, 271);
insert into account values(1000, 272);
insert into account values(1000, 273);
insert into account values(1000, 274);
insert into account values(1000, 275);
insert into account values(1000, 276);
insert into account values(1000, 277);
insert into account values(1000, 278);
insert into account values(1000, 279);
insert into account values(1000, 280);
insert into account values(1000, 281);
insert into account values(1000, 282);
insert into account values(1000, 283);
insert into account values(1000, 284);
insert into account values(1000, 285);
insert into account values(1000, 286);
insert into account values(1000, 287);
insert into account values(1000, 288);
insert into account values(1000, 289);
insert into account values(1000, 290);
insert into account values(1000, 291);
insert into account values(1000, 292);
insert into account values(1000, 293);
insert into account values(1000, 294);
insert into account values(1000, 295);
insert into account values(1000, 296);
insert into account values(1000, 297);
insert into account values(1000, 298);
insert into account values(1000, 299);
insert into account values(1000, 300);
commit;
insert into account values(1000, 301);
insert into account values(1000, 302);
insert into account values(1000, 303);
insert into account values(1000, 304);
insert into account values(1000, 305);
insert into account values(1000, 306);
insert into account values(1000, 307);
insert into account values(1000, 308);
insert into account values(1000, 309);
insert into account values(1000, 310);
insert into account values(1000, 311);
insert into account values(1000, 312);
insert into account values(1000, 313);
insert into account values(1000, 314);
insert into account values(1000, 315);
insert into account values(1000, 316);
insert into account values(1000, 317);
insert into account values(1000, 318);
insert into account values(1000, 319);
insert into account values(1000, 320);
insert into account values(1000, 321);
insert into account values(1000, 322);
insert into account values(1000, 323);
insert into account values(1000, 324);
insert into account values(1000, 325);
insert into account values(1000, 326);
insert into account values(1000, 327);
insert into account values(1000, 328);
insert into account values(1000, 329);
insert into account values(1000, 330);
insert into account values(1000, 331);
insert into account values(1000, 332);
insert into account values(1000, 333);
insert into account values(1000, 334);
insert into account values(1000, 335);
insert into account values(1000, 336);
insert into account values(1000, 337);
insert into account values(1000, 338);
insert into account values(1000, 339);
insert into account values(1000, 340);
insert into account values(1000, 341);
insert into account values(1000, 342);
insert into account values(1000, 343);
insert into account values(1000, 344);
insert into account values(1000, 345);
insert into account values(1000, 346);
insert into account values(1000, 347);
insert into account values(1000, 348);
insert into account values(1000, 349);
insert into account values(1000, 350);
insert into account values(1000, 351);
insert into account values(1000, 352);
insert into account values(1000, 353);
insert into account values(1000, 354);
insert into account values(1000, 355);
insert into account values(1000, 356);
insert into account values(1000, 357);
insert into account values(1000, 358);
insert into account values(1000, 359);
insert into account values(1000, 360);
insert into account values(1000, 361);
insert into account values(1000, 362);
insert into account values(1000, 363);
insert into account values(1000, 364);
insert into account values(1000, 365);
insert into account values(1000, 366);
insert into account values(1000, 367);
insert into account values(1000, 368);
insert into account values(1000, 369);
insert into account values(1000, 370);
insert into account values(1000, 371);
insert into account values(1000, 372);
insert into account values(1000, 373);
insert into account values(1000, 374);
insert into account values(1000, 375);
insert into account values(1000, 376);
insert into account values(1000, 377);
insert into account values(1000, 378);
insert into account values(1000, 379);
insert into account values(1000, 380);
insert into account values(1000, 381);
insert into account values(1000, 382);
insert into account values(1000, 383);
insert into account values(1000, 384);
insert into account values(1000, 385);
insert into account values(1000, 386);
insert into account values(1000, 387);
insert into account values(1000, 388);
insert into account values(1000, 389);
insert into account values(1000, 390);
insert into account values(1000, 391);
insert into account values(1000, 392);
insert into account values(1000, 393);
insert into account values(1000, 394);
insert into account values(1000, 395);
insert into account values(1000, 396);
insert into account values(1000, 397);
insert into account values(1000, 398);
insert into account values(1000, 399);
insert into account values(1000, 400);
commit;
insert into account values(1000, 401);
insert into account values(1000, 402);
insert into account values(1000, 403);
insert into account values(1000, 404);
insert into account values(1000, 405);
insert into account values(1000, 406);
insert into account values(1000, 407);
insert into account values(1000, 408);
insert into account values(1000, 409);
insert into account values(1000, 410);
insert into account values(1000, 411);
insert into account values(1000, 412);
insert into account values(1000, 413);
insert into account values(1000, 414);
insert into account values(1000, 415);
insert into account values(1000, 416);
insert into account values(1000, 417);
insert into account values(1000, 418);
insert into account values(1000, 419);
insert into account values(1000, 420);
insert into account values(1000, 421);
insert into account values(1000, 422);
insert into account values(1000, 423);
insert into account values(1000, 424);
insert into account values(1000, 425);
insert into account values(1000, 426);
insert into account values(1000, 427);
insert into account values(1000, 428);
insert into account values(1000, 429);
insert into account values(1000, 430);
insert into account values(1000, 431);
insert into account values(1000, 432);
insert into account values(1000, 433);
insert into account values(1000, 434);
insert into account values(1000, 435);
insert into account values(1000, 436);
insert into account values(1000, 437);
insert into account values(1000, 438);
insert into account values(1000, 439);
insert into account values(1000, 440);
insert into account values(1000, 441);
insert into account values(1000, 442);
insert into account values(1000, 443);
insert into account values(1000, 444);
insert into account values(1000, 445);
insert into account values(1000, 446);
insert into account values(1000, 447);
insert into account values(1000, 448);
insert into account values(1000, 449);
insert into account values(1000, 450);
insert into account values(1000, 451);
insert into account values(1000, 452);
insert into account values(1000, 453);
insert into account values(1000, 454);
insert into account values(1000, 455);
insert into account values(1000, 456);
insert into account values(1000, 457);
insert into account values(1000, 458);
insert into account values(1000, 459);
insert into account values(1000, 460);
insert into account values(1000, 461);
insert into account values(1000, 462);
insert into account values(1000, 463);
insert into account values(1000, 464);
insert into account values(1000, 465);
insert into account values(1000, 466);
insert into account values(1000, 467);
insert into account values(1000, 468);
insert into account values(1000, 469);
insert into account values(1000, 470);
insert into account values(1000, 471);
insert into account values(1000, 472);
insert into account values(1000, 473);
insert into account values(1000, 474);
insert into account values(1000, 475);
insert into account values(1000, 476);
insert into account values(1000, 477);
insert into account values(1000, 478);
insert into account values(1000, 479);
insert into account values(1000, 480);
insert into account values(1000, 481);
insert into account values(1000, 482);
insert into account values(1000, 483);
insert into account values(1000, 484);
insert into account values(1000, 485);
insert into account values(1000, 486);
insert into account values(1000, 487);
insert into account values(1000, 488);
insert into account values(1000, 489);
insert into account values(1000, 490);
insert into account values(1000, 491);
insert into account values(1000, 492);
insert into account values(1000, 493);
insert into account values(1000, 494);
insert into account values(1000, 495);
insert into account values(1000, 496);
insert into account values(1000, 497);
insert into account values(1000, 498);
insert into account values(1000, 499);
insert into account values(1000, 500);
commit;
insert into account values(1000, 501);
insert into account values(1000, 502);
insert into account values(1000, 503);
insert into account values(1000, 504);
insert into account values(1000, 505);
insert into account values(1000, 506);
insert into account values(1000, 507);
insert into account values(1000, 508);
insert into account values(1000, 509);
insert into account values(1000, 510);
insert into account values(1000, 511);
insert into account values(1000, 512);
insert into account values(1000, 513);
insert into account values(1000, 514);
insert into account values(1000, 515);
insert into account values(1000, 516);
insert into account values(1000, 517);
insert into account values(1000, 518);
insert into account values(1000, 519);
insert into account values(1000, 520);
insert into account values(1000, 521);
insert into account values(1000, 522);
insert into account values(1000, 523);
insert into account values(1000, 524);
insert into account values(1000, 525);
insert into account values(1000, 526);
insert into account values(1000, 527);
insert into account values(1000, 528);
insert into account values(1000, 529);
insert into account values(1000, 530);
insert into account values(1000, 531);
insert into account values(1000, 532);
insert into account values(1000, 533);
insert into account values(1000, 534);
insert into account values(1000, 535);
insert into account values(1000, 536);
insert into account values(1000, 537);
insert into account values(1000, 538);
insert into account values(1000, 539);
insert into account values(1000, 540);
insert into account values(1000, 541);
insert into account values(1000, 542);
insert into account values(1000, 543);
insert into account values(1000, 544);
insert into account values(1000, 545);
insert into account values(1000, 546);
insert into account values(1000, 547);
insert into account values(1000, 548);
insert into account values(1000, 549);
insert into account values(1000, 550);
insert into account values(1000, 551);
insert into account values(1000, 552);
insert into account values(1000, 553);
insert into account values(1000, 554);
insert into account values(1000, 555);
insert into account values(1000, 556);
insert into account values(1000, 557);
insert into account values(1000, 558);
insert into account values(1000, 559);
insert into account values(1000, 560);
insert into account values(1000, 561);
insert into account values(1000, 562);
insert into account values(1000, 563);
insert into account values(1000, 564);
insert into account values(1000, 565);
insert into account values(1000, 566);
insert into account values(1000, 567);
insert into account values(1000, 568);
insert into account values(1000, 569);
insert into account values(1000, 570);
insert into account values(1000, 571);
insert into account values(1000, 572);
insert into account values(1000, 573);
insert into account values(1000, 574);
insert into account values(1000, 575);
insert into account values(1000, 576);
insert into account values(1000, 577);
insert into account values(1000, 578);
insert into account values(1000, 579);
insert into account values(1000, 580);
insert into account values(1000, 581);
insert into account values(1000, 582);
insert into account values(1000, 583);
insert into account values(1000, 584);
insert into account values(1000, 585);
insert into account values(1000, 586);
insert into account values(1000, 587);
insert into account values(1000, 588);
insert into account values(1000, 589);
insert into account values(1000, 590);
insert into account values(1000, 591);
insert into account values(1000, 592);
insert into account values(1000, 593);
insert into account values(1000, 594);
insert into account values(1000, 595);
insert into account values(1000, 596);
insert into account values(1000, 597);
insert into account values(1000, 598);
insert into account values(1000, 599);
insert into account values(1000, 600);
commit;
insert into account values(1000, 601);
insert into account values(1000, 602);
insert into account values(1000, 603);
insert into account values(1000, 604);
insert into account values(1000, 605);
insert into account values(1000, 606);
insert into account values(1000, 607);
insert into account values(1000, 608);
insert into account values(1000, 609);
insert into account values(1000, 610);
insert into account values(1000, 611);
insert into account values(1000, 612);
insert into account values(1000, 613);
insert into account values(1000, 614);
insert into account values(1000, 615);
insert into account values(1000, 616);
insert into account values(1000, 617);
insert into account values(1000, 618);
insert into account values(1000, 619);
insert into account values(1000, 620);
insert into account values(1000, 621);
insert into account values(1000, 622);
insert into account values(1000, 623);
insert into account values(1000, 624);
insert into account values(1000, 625);
insert into account values(1000, 626);
insert into account values(1000, 627);
insert into account values(1000, 628);
insert into account values(1000, 629);
insert into account values(1000, 630);
insert into account values(1000, 631);
insert into account values(1000, 632);
insert into account values(1000, 633);
insert into account values(1000, 634);
insert into account values(1000, 635);
insert into account values(1000, 636);
insert into account values(1000, 637);
insert into account values(1000, 638);
insert into account values(1000, 639);
insert into account values(1000, 640);
insert into account values(1000, 641);
insert into account values(1000, 642);
insert into account values(1000, 643);
insert into account values(1000, 644);
insert into account values(1000, 645);
insert into account values(1000, 646);
insert into account values(1000, 647);
insert into account values(1000, 648);
insert into account values(1000, 649);
insert into account values(1000, 650);
insert into account values(1000, 651);
insert into account values(1000, 652);
insert into account values(1000, 653);
insert into account values(1000, 654);
insert into account values(1000, 655);
insert into account values(1000, 656);
insert into account values(1000, 657);
insert into account values(1000, 658);
insert into account values(1000, 659);
insert into account values(1000, 660);
insert into account values(1000, 661);
insert into account values(1000, 662);
insert into account values(1000, 663);
insert into account values(1000, 664);
insert into account values(1000, 665);
insert into account values(1000, 666);
insert into account values(1000, 667);
insert into account values(1000, 668);
insert into account values(1000, 669);
insert into account values(1000, 670);
insert into account values(1000, 671);
insert into account values(1000, 672);
insert into account values(1000, 673);
insert into account values(1000, 674);
insert into account values(1000, 675);
insert into account values(1000, 676);
insert into account values(1000, 677);
insert into account values(1000, 678);
insert into account values(1000, 679);
insert into account values(1000, 680);
insert into account values(1000, 681);
insert into account values(1000, 682);
insert into account values(1000, 683);
insert into account values(1000, 684);
insert into account values(1000, 685);
insert into account values(1000, 686);
insert into account values(1000, 687);
insert into account values(1000, 688);
insert into account values(1000, 689);
insert into account values(1000, 690);
insert into account values(1000, 691);
insert into account values(1000, 692);
insert into account values(1000, 693);
insert into account values(1000, 694);
insert into account values(1000, 695);
insert into account values(1000, 696);
insert into account values(1000, 697);
insert into account values(1000, 698);
insert into account values(1000, 699);
insert into account values(1000, 700);
commit;
insert into account values(1000, 701);
insert into account values(1000, 702);
insert into account values(1000, 703);
insert into account values(1000, 704);
insert into account values(1000, 705);
insert into account values(1000, 706);
insert into account values(1000, 707);
insert into account values(1000, 708);
insert into account values(1000, 709);
insert into account values(1000, 710);
insert into account values(1000, 711);
insert into account values(1000, 712);
insert into account values(1000, 713);
insert into account values(1000, 714);
insert into account values(1000, 715);
insert into account values(1000, 716);
insert into account values(1000, 717);
insert into account values(1000, 718);
insert into account values(1000, 719);
insert into account values(1000, 720);
insert into account values(1000, 721);
insert into account values(1000, 722);
insert into account values(1000, 723);
insert into account values(1000, 724);
insert into account values(1000, 725);
insert into account values(1000, 726);
insert into account values(1000, 727);
insert into account values(1000, 728);
insert into account values(1000, 729);
insert into account values(1000, 730);
insert into account values(1000, 731);
insert into account values(1000, 732);
insert into account values(1000, 733);
insert into account values(1000, 734);
insert into account values(1000, 735);
insert into account values(1000, 736);
insert into account values(1000, 737);
insert into account values(1000, 738);
insert into account values(1000, 739);
insert into account values(1000, 740);
insert into account values(1000, 741);
insert into account values(1000, 742);
insert into account values(1000, 743);
insert into account values(1000, 744);
insert into account values(1000, 745);
insert into account values(1000, 746);
insert into account values(1000, 747);
insert into account values(1000, 748);
insert into account values(1000, 749);
insert into account values(1000, 750);
insert into account values(1000, 751);
insert into account values(1000, 752);
insert into account values(1000, 753);
insert into account values(1000, 754);
insert into account values(1000, 755);
insert into account values(1000, 756);
insert into account values(1000, 757);
insert into account values(1000, 758);
insert into account values(1000, 759);
insert into account values(1000, 760);
insert into account values(1000, 761);
insert into account values(1000, 762);
insert into account values(1000, 763);
insert into account values(1000, 764);
insert into account values(1000, 765);
insert into account values(1000, 766);
insert into account values(1000, 767);
insert into account values(1000, 768);
insert into account values(1000, 769);
insert into account values(1000, 770);
insert into account values(1000, 771);
insert into account values(1000, 772);
insert into account values(1000, 773);
insert into account values(1000, 774);
insert into account values(1000, 775);
insert into account values(1000, 776);
insert into account values(1000, 777);
insert into account values(1000, 778);
insert into account values(1000, 779);
insert into account values(1000, 780);
insert into account values(1000, 781);
insert into account values(1000, 782);
insert into account values(1000, 783);
insert into account values(1000, 784);
insert into account values(1000, 785);
insert into account values(1000, 786);
insert into account values(1000, 787);
insert into account values(1000, 788);
insert into account values(1000, 789);
insert into account values(1000, 790);
insert into account values(1000, 791);
insert into account values(1000, 792);
insert into account values(1000, 793);
insert into account values(1000, 794);
insert into account values(1000, 795);
insert into account values(1000, 796);
insert into account values(1000, 797);
insert into account values(1000, 798);
insert into account values(1000, 799);
insert into account values(1000, 800);
commit;
insert into account values(1000, 801);
insert into account values(1000, 802);
insert into account values(1000, 803);
insert into account values(1000, 804);
insert into account values(1000, 805);
insert into account values(1000, 806);
insert into account values(1000, 807);
insert into account values(1000, 808);
insert into account values(1000, 809);
insert into account values(1000, 810);
insert into account values(1000, 811);
insert into account values(1000, 812);
insert into account values(1000, 813);
insert into account values(1000, 814);
insert into account values(1000, 815);
insert into account values(1000, 816);
insert into account values(1000, 817);
insert into account values(1000, 818);
insert into account values(1000, 819);
insert into account values(1000, 820);
insert into account values(1000, 821);
insert into account values(1000, 822);
insert into account values(1000, 823);
insert into account values(1000, 824);
insert into account values(1000, 825);
insert into account values(1000, 826);
insert into account values(1000, 827);
insert into account values(1000, 828);
insert into account values(1000, 829);
insert into account values(1000, 830);
insert into account values(1000, 831);
insert into account values(1000, 832);
insert into account values(1000, 833);
insert into account values(1000, 834);
insert into account values(1000, 835);
insert into account values(1000, 836);
insert into account values(1000, 837);
insert into account values(1000, 838);
insert into account values(1000, 839);
insert into account values(1000, 840);
insert into account values(1000, 841);
insert into account values(1000, 842);
insert into account values(1000, 843);
insert into account values(1000, 844);
insert into account values(1000, 845);
insert into account values(1000, 846);
insert into account values(1000, 847);
insert into account values(1000, 848);
insert into account values(1000, 849);
insert into account values(1000, 850);
insert into account values(1000, 851);
insert into account values(1000, 852);
insert into account values(1000, 853);
insert into account values(1000, 854);
insert into account values(1000, 855);
insert into account values(1000, 856);
insert into account values(1000, 857);
insert into account values(1000, 858);
insert into account values(1000, 859);
insert into account values(1000, 860);
insert into account values(1000, 861);
insert into account values(1000, 862);
insert into account values(1000, 863);
insert into account values(1000, 864);
insert into account values(1000, 865);
insert into account values(1000, 866);
insert into account values(1000, 867);
insert into account values(1000, 868);
insert into account values(1000, 869);
insert into account values(1000, 870);
insert into account values(1000, 871);
insert into account values(1000, 872);
insert into account values(1000, 873);
insert into account values(1000, 874);
insert into account values(1000, 875);
insert into account values(1000, 876);
insert into account values(1000, 877);
insert into account values(1000, 878);
insert into account values(1000, 879);
insert into account values(1000, 880);
insert into account values(1000, 881);
insert into account values(1000, 882);
insert into account values(1000, 883);
insert into account values(1000, 884);
insert into account values(1000, 885);
insert into account values(1000, 886);
insert into account values(1000, 887);
insert into account values(1000, 888);
insert into account values(1000, 889);
insert into account values(1000, 890);
insert into account values(1000, 891);
insert into account values(1000, 892);
insert into account values(1000, 893);
insert into account values(1000, 894);
insert into account values(1000, 895);
insert into account values(1000, 896);
insert into account values(1000, 897);
insert into account values(1000, 898);
insert into account values(1000, 899);
insert into account values(1000, 900);
commit;
insert into account values(1000, 901);
insert into account values(1000, 902);
insert into account values(1000, 903);
insert into account values(1000, 904);
insert into account values(1000, 905);
insert into account values(1000, 906);
insert into account values(1000, 907);
insert into account values(1000, 908);
insert into account values(1000, 909);
insert into account values(1000, 910);
insert into account values(1000, 911);
insert into account values(1000, 912);
insert into account values(1000, 913);
insert into account values(1000, 914);
insert into account values(1000, 915);
insert into account values(1000, 916);
insert into account values(1000, 917);
insert into account values(1000, 918);
insert into account values(1000, 919);
insert into account values(1000, 920);
insert into account values(1000, 921);
insert into account values(1000, 922);
insert into account values(1000, 923);
insert into account values(1000, 924);
insert into account values(1000, 925);
insert into account values(1000, 926);
insert into account values(1000, 927);
insert into account values(1000, 928);
insert into account values(1000, 929);
insert into account values(1000, 930);
insert into account values(1000, 931);
insert into account values(1000, 932);
insert into account values(1000, 933);
insert into account values(1000, 934);
insert into account values(1000, 935);
insert into account values(1000, 936);
insert into account values(1000, 937);
insert into account values(1000, 938);
insert into account values(1000, 939);
insert into account values(1000, 940);
insert into account values(1000, 941);
insert into account values(1000, 942);
insert into account values(1000, 943);
insert into account values(1000, 944);
insert into account values(1000, 945);
insert into account values(1000, 946);
insert into account values(1000, 947);
insert into account values(1000, 948);
insert into account values(1000, 949);
insert into account values(1000, 950);
insert into account values(1000, 951);
insert into account values(1000, 952);
insert into account values(1000, 953);
insert into account values(1000, 954);
insert into account values(1000, 955);
insert into account values(1000, 956);
insert into account values(1000, 957);
insert into account values(1000, 958);
insert into account values(1000, 959);
insert into account values(1000, 960);
insert into account values(1000, 961);
insert into account values(1000, 962);
insert into account values(1000, 963);
insert into account values(1000, 964);
insert into account values(1000, 965);
insert into account values(1000, 966);
insert into account values(1000, 967);
insert into account values(1000, 968);
insert into account values(1000, 969);
insert into account values(1000, 970);
insert into account values(1000, 971);
insert into account values(1000, 972);
insert into account values(1000, 973);
insert into account values(1000, 974);
insert into account values(1000, 975);
insert into account values(1000, 976);
insert into account values(1000, 977);
insert into account values(1000, 978);
insert into account values(1000, 979);
insert into account values(1000, 980);
insert into account values(1000, 981);
insert into account values(1000, 982);
insert into account values(1000, 983);
insert into account values(1000, 984);
insert into account values(1000, 985);
insert into account values(1000, 986);
insert into account values(1000, 987);
insert into account values(1000, 988);
insert into account values(1000, 989);
insert into account values(1000, 990);
insert into account values(1000, 991);
insert into account values(1000, 992);
insert into account values(1000, 993);
insert into account values(1000, 994);
insert into account values(1000, 995);
insert into account values(1000, 996);
insert into account values(1000, 997);
insert into account values(1000, 998);
insert into account values(1000, 999);
insert into account values(1000, 1000);
commit;

Rem ************************************************************
Rem Create the RECEIPT table for the VB Sample application 
Rem provided with Microsoft Transaction Server
Rem ************************************************************

drop table Receipt;
create table Receipt (NextReceipt number) initrans 100 maxtrans 255;
insert into Receipt values (100);
commit;

Rem ************************************************************
Rem Create the accounts table
Rem ************************************************************

DROP TABLE accounts;
CREATE TABLE accounts (
                        acctnum_accounts number(8),
                        acctpin_accounts number(8),
                        currbal_accounts number(10),
                        acctown_accounts char(20),
                        crtdate_accounts date
                     )
               PCTFREE    0   	PCTUSED    99
               INITRANS   100  	MAXTRANS   255;

Rem ************************************************************
Rem Create the txacts table to hold txn records
Rem ************************************************************

DROP TABLE txacts;
CREATE TABLE txacts (
                      txntype_txacts  varchar2(10),
                      txnacct_txacts  number(8),
                      txnamnt_txacts  number(10)
                    )
               PCTFREE    0   	PCTUSED    99
               INITRANS   100  	MAXTRANS   255;

Rem ************************************************************
Rem Create the package to help us perform txns. on the accounts 
Rem table
Rem ************************************************************

CREATE OR REPLACE PACKAGE oramtssamp AS
   /* Declare externally callable procedures. */
   FUNCTION do_credit(
                       acctnum NUMBER, 
                       acctpin NUMBER, 
                       amount  REAL,
			           balance OUT NUMBER
		            ) RETURN NUMBER;
   FUNCTION do_debit(
                      acctnum NUMBER, 
		              acctpin NUMBER, 
                      amount  REAL,
		              balance OUT NUMBER
		            ) RETURN NUMBER;
   FUNCTION do_balance(
                       acctnum NUMBER, 
                       acctpin NUMBER, 
		               balance OUT NUMBER
		             ) RETURN NUMBER;
   FUNCTION do_transfer(
                        fracnum NUMBER, 
                        fracpin NUMBER, 
                        toacnum NUMBER, 
                        amount  REAL,
			            balance OUT NUMBER
		              ) RETURN NUMBER;
END oramtssamp;
/
CREATE OR REPLACE PACKAGE BODY oramtssamp AS
   FUNCTION do_credit(
                       acctnum NUMBER, 
                       acctpin NUMBER, 
		               amount  REAL,
		               balance OUT NUMBER
		            ) RETURN NUMBER 
   IS
     retval NUMBER;
   BEGIN
      balance := 0;
	  retval  := 0;
      /*------ update the accounts table --------*/
      UPDATE accounts 
	    SET currbal_accounts = currbal_accounts + amount
      WHERE 
	   ( acctnum_accounts  = acctnum 
	       AND 
		 acctpin_accounts  = acctpin 
	   );
      /*------ get the new balance -------------*/
      SELECT currbal_accounts 
	     INTO balance 
      FROM accounts
      WHERE 
	   ( acctnum_accounts  = acctnum 
	       AND 
		 acctpin_accounts  = acctpin 
	   );
       RETURN retval;

EXCEPTION
      WHEN NO_DATA_FOUND THEN
      BEGIN
         retval := SQLCODE;
         RETURN retval;
      END;

WHEN OTHERS THEN
	  BEGIN
           retval := SQLCODE;
           RETURN retval;
	  END;
   END do_credit;

FUNCTION do_debit(
                     acctnum NUMBER, 
                     acctpin NUMBER, 
                     amount  REAL,
                     balance OUT NUMBER
				   ) RETURN NUMBER
   IS
      insufficient_funds EXCEPTION;
      retval      NUMBER;
   BEGIN
      balance := 0;
      retval  := 0;
      /*------ update the accounts table --------*/
      UPDATE accounts 
	    SET currbal_accounts = currbal_accounts - amount
      WHERE 
	   ( 
	     (acctnum_accounts  = acctnum)
	       AND 
		 (acctpin_accounts  = acctpin)
		   AND 
         (currbal_accounts - amount) > 0
	   );
      /*------ get the new balance -------------*/
      SELECT currbal_accounts 
	    INTO balance 
	  FROM accounts
      WHERE 
	   (
 	     (acctnum_accounts  = acctnum)
	       AND 
		 (acctpin_accounts  = acctpin)
	   );
       RETURN retval;

EXCEPTION
      WHEN NO_DATA_FOUND THEN
	  BEGIN
           retval := SQLCODE;
           RETURN retval;
	  END;
      WHEN insufficient_funds THEN
	  BEGIN
           retval := SQLCODE;
           RETURN retval;
	  END;
      WHEN OTHERS THEN
	  BEGIN
           retval := SQLCODE;
           RETURN retval;
	  END;
   END do_debit;

FUNCTION do_balance(
                       acctnum NUMBER, 
		               acctpin NUMBER, 
		               balance OUT NUMBER
                      ) RETURN NUMBER
   IS 
      retval NUMBER;
   BEGIN   
      balance := 0;
      retval  := 0;
      SELECT currbal_accounts 
	    INTO balance 
	  FROM accounts
      WHERE 
	   (
 	     (acctnum_accounts  = acctnum)
	       AND 
		 (acctpin_accounts  = acctpin)
	   );
       RETURN retval;

EXCEPTION
      WHEN NO_DATA_FOUND THEN
	  BEGIN
           retval := SQLCODE;
           RETURN retval;
	  END;

WHEN OTHERS THEN
	  BEGIN
           retval := SQLCODE;
           RETURN retval;
	  END;
   END do_balance;

FUNCTION do_transfer(
                        fracnum NUMBER, 
                        fracpin NUMBER, 
                        toacnum NUMBER, 
                        amount  REAL,
			            balance OUT NUMBER
		              ) RETURN NUMBER
   IS 
      retval NUMBER;
   BEGIN   
      balance := 0;
      retval  := 0;
      /*------ debit the from account ----------*/
      UPDATE accounts 
	    SET currbal_accounts = currbal_accounts - amount
      WHERE 
	   ( 
	     (acctnum_accounts  = fracnum)
	       AND 
		 (acctpin_accounts  = fracpin)
		   AND 
         (currbal_accounts - amount) > 0
	   );
      /*------ credit the to account -----------*/
      UPDATE accounts 
	    SET currbal_accounts = currbal_accounts + amount
      WHERE 
	     (acctnum_accounts  = toacnum);
      /*------ get the new balance -------------*/
      SELECT currbal_accounts 
	    INTO balance 
	  FROM accounts
      WHERE 
	   (
 	     (acctnum_accounts  = fracnum)
	       AND 
		 (acctpin_accounts  = fracpin)
	   );
      RETURN retval;

EXCEPTION
      WHEN NO_DATA_FOUND THEN
	  BEGIN
        retval := SQLCODE;
        RETURN retval;
	  END;

WHEN OTHERS THEN
	  BEGIN
        retval := SQLCODE;
        RETURN retval;
	  END;
   END do_transfer;

END oramtssamp;
/

Rem ************************************************************
Rem Insert table data into the accounts table
Rem ************************************************************

INSERT INTO accounts VALUES (0000,0000, 10000, 'USER0000', SYSDATE);
INSERT INTO accounts VALUES (0001,0001, 10000, 'USER0001', SYSDATE);
INSERT INTO accounts VALUES (0002,0002, 10000, 'USER0002', SYSDATE);
INSERT INTO accounts VALUES (0003,0003, 10000, 'USER0003', SYSDATE);
INSERT INTO accounts VALUES (0004,0004, 10000, 'USER0004', SYSDATE);
INSERT INTO accounts VALUES (0005,0005, 10000, 'USER0005', SYSDATE);
INSERT INTO accounts VALUES (0006,0006, 10000, 'USER0006', SYSDATE);
INSERT INTO accounts VALUES (0007,0007, 10000, 'USER0007', SYSDATE);
INSERT INTO accounts VALUES (0008,0008, 10000, 'USER0008', SYSDATE);
INSERT INTO accounts VALUES (0009,0009, 10000, 'USER0009', SYSDATE);
INSERT INTO accounts VALUES (0010,0010, 10000, 'USER0010', SYSDATE);
INSERT INTO accounts VALUES (0011,0011, 10000, 'USER0011', SYSDATE);
INSERT INTO accounts VALUES (0012,0012, 10000, 'USER0012', SYSDATE);
INSERT INTO accounts VALUES (0013,0013, 10000, 'USER0013', SYSDATE);
INSERT INTO accounts VALUES (0014,0014, 10000, 'USER0014', SYSDATE);
INSERT INTO accounts VALUES (0015,0015, 10000, 'USER0015', SYSDATE);
INSERT INTO accounts VALUES (0016,0016, 10000, 'USER0016', SYSDATE);
INSERT INTO accounts VALUES (0017,0017, 10000, 'USER0017', SYSDATE);
INSERT INTO accounts VALUES (0018,0018, 10000, 'USER0018', SYSDATE);
INSERT INTO accounts VALUES (0019,0019, 10000, 'USER0019', SYSDATE);
INSERT INTO accounts VALUES (0020,0020, 10000, 'USER0020', SYSDATE);
INSERT INTO accounts VALUES (0021,0021, 10000, 'USER0021', SYSDATE);
INSERT INTO accounts VALUES (0022,0022, 10000, 'USER0022', SYSDATE);
INSERT INTO accounts VALUES (0023,0023, 10000, 'USER0023', SYSDATE);
INSERT INTO accounts VALUES (0024,0024, 10000, 'USER0024', SYSDATE);
INSERT INTO accounts VALUES (0025,0025, 10000, 'USER0025', SYSDATE);
INSERT INTO accounts VALUES (0026,0026, 10000, 'USER0026', SYSDATE);
INSERT INTO accounts VALUES (0027,0027, 10000, 'USER0027', SYSDATE);
INSERT INTO accounts VALUES (0028,0028, 10000, 'USER0028', SYSDATE);
INSERT INTO accounts VALUES (0029,0029, 10000, 'USER0029', SYSDATE);
INSERT INTO accounts VALUES (0030,0030, 10000, 'USER0030', SYSDATE);
INSERT INTO accounts VALUES (0031,0031, 10000, 'USER0031', SYSDATE);
INSERT INTO accounts VALUES (0032,0032, 10000, 'USER0032', SYSDATE);
INSERT INTO accounts VALUES (0033,0033, 10000, 'USER0033', SYSDATE);
INSERT INTO accounts VALUES (0034,0034, 10000, 'USER0034', SYSDATE);
INSERT INTO accounts VALUES (0035,0035, 10000, 'USER0035', SYSDATE);
INSERT INTO accounts VALUES (0036,0036, 10000, 'USER0036', SYSDATE);
INSERT INTO accounts VALUES (0037,0037, 10000, 'USER0037', SYSDATE);
INSERT INTO accounts VALUES (0038,0038, 10000, 'USER0038', SYSDATE);
INSERT INTO accounts VALUES (0039,0039, 10000, 'USER0039', SYSDATE);
INSERT INTO accounts VALUES (0040,0040, 10000, 'USER0040', SYSDATE);
INSERT INTO accounts VALUES (0041,0041, 10000, 'USER0041', SYSDATE);
INSERT INTO accounts VALUES (0042,0042, 10000, 'USER0042', SYSDATE);
INSERT INTO accounts VALUES (0043,0043, 10000, 'USER0043', SYSDATE);
INSERT INTO accounts VALUES (0044,0044, 10000, 'USER0044', SYSDATE);
INSERT INTO accounts VALUES (0045,0045, 10000, 'USER0045', SYSDATE);
INSERT INTO accounts VALUES (0046,0046, 10000, 'USER0046', SYSDATE);
INSERT INTO accounts VALUES (0047,0047, 10000, 'USER0047', SYSDATE);
INSERT INTO accounts VALUES (0048,0048, 10000, 'USER0048', SYSDATE);
INSERT INTO accounts VALUES (0049,0049, 10000, 'USER0049', SYSDATE);
INSERT INTO accounts VALUES (0050,0050, 10000, 'USER0050', SYSDATE);
INSERT INTO accounts VALUES (0051,0051, 10000, 'USER0051', SYSDATE);
INSERT INTO accounts VALUES (0052,0052, 10000, 'USER0052', SYSDATE);
INSERT INTO accounts VALUES (0053,0053, 10000, 'USER0053', SYSDATE);
INSERT INTO accounts VALUES (0054,0054, 10000, 'USER0054', SYSDATE);
INSERT INTO accounts VALUES (0055,0055, 10000, 'USER0055', SYSDATE);
INSERT INTO accounts VALUES (0056,0056, 10000, 'USER0056', SYSDATE);
INSERT INTO accounts VALUES (0057,0057, 10000, 'USER0057', SYSDATE);
INSERT INTO accounts VALUES (0058,0058, 10000, 'USER0058', SYSDATE);
INSERT INTO accounts VALUES (0059,0059, 10000, 'USER0059', SYSDATE);
INSERT INTO accounts VALUES (0060,0060, 10000, 'USER0060', SYSDATE);
INSERT INTO accounts VALUES (0061,0061, 10000, 'USER0061', SYSDATE);
INSERT INTO accounts VALUES (0062,0062, 10000, 'USER0062', SYSDATE);
INSERT INTO accounts VALUES (0063,0063, 10000, 'USER0063', SYSDATE);
INSERT INTO accounts VALUES (0064,0064, 10000, 'USER0064', SYSDATE);
INSERT INTO accounts VALUES (0065,0065, 10000, 'USER0065', SYSDATE);
INSERT INTO accounts VALUES (0066,0066, 10000, 'USER0066', SYSDATE);
INSERT INTO accounts VALUES (0067,0067, 10000, 'USER0067', SYSDATE);
INSERT INTO accounts VALUES (0068,0068, 10000, 'USER0068', SYSDATE);
INSERT INTO accounts VALUES (0069,0069, 10000, 'USER0069', SYSDATE);
INSERT INTO accounts VALUES (0070,0070, 10000, 'USER0070', SYSDATE);
INSERT INTO accounts VALUES (0071,0071, 10000, 'USER0071', SYSDATE);
INSERT INTO accounts VALUES (0072,0072, 10000, 'USER0072', SYSDATE);
INSERT INTO accounts VALUES (0073,0073, 10000, 'USER0073', SYSDATE);
INSERT INTO accounts VALUES (0074,0074, 10000, 'USER0074', SYSDATE);
INSERT INTO accounts VALUES (0075,0075, 10000, 'USER0075', SYSDATE);
INSERT INTO accounts VALUES (0076,0076, 10000, 'USER0076', SYSDATE);
INSERT INTO accounts VALUES (0077,0077, 10000, 'USER0077', SYSDATE);
INSERT INTO accounts VALUES (0078,0078, 10000, 'USER0078', SYSDATE);
INSERT INTO accounts VALUES (0079,0079, 10000, 'USER0079', SYSDATE);
INSERT INTO accounts VALUES (0080,0080, 10000, 'USER0080', SYSDATE);
INSERT INTO accounts VALUES (0081,0081, 10000, 'USER0081', SYSDATE);
INSERT INTO accounts VALUES (0082,0082, 10000, 'USER0082', SYSDATE);
INSERT INTO accounts VALUES (0083,0083, 10000, 'USER0083', SYSDATE);
INSERT INTO accounts VALUES (0084,0084, 10000, 'USER0084', SYSDATE);
INSERT INTO accounts VALUES (0085,0085, 10000, 'USER0085', SYSDATE);
INSERT INTO accounts VALUES (0086,0086, 10000, 'USER0086', SYSDATE);
INSERT INTO accounts VALUES (0087,0087, 10000, 'USER0087', SYSDATE);
INSERT INTO accounts VALUES (0088,0088, 10000, 'USER0088', SYSDATE);
INSERT INTO accounts VALUES (0089,0089, 10000, 'USER0089', SYSDATE);
INSERT INTO accounts VALUES (0090,0090, 10000, 'USER0090', SYSDATE);
INSERT INTO accounts VALUES (0091,0091, 10000, 'USER0091', SYSDATE);
INSERT INTO accounts VALUES (0092,0092, 10000, 'USER0092', SYSDATE);
INSERT INTO accounts VALUES (0093,0093, 10000, 'USER0093', SYSDATE);
INSERT INTO accounts VALUES (0094,0094, 10000, 'USER0094', SYSDATE);
INSERT INTO accounts VALUES (0095,0095, 10000, 'USER0095', SYSDATE);
INSERT INTO accounts VALUES (0096,0096, 10000, 'USER0096', SYSDATE);
INSERT INTO accounts VALUES (0097,0097, 10000, 'USER0097', SYSDATE);
INSERT INTO accounts VALUES (0098,0098, 10000, 'USER0098', SYSDATE);
INSERT INTO accounts VALUES (0099,0099, 10000, 'USER0099', SYSDATE);
INSERT INTO accounts VALUES (0100,0100, 10000, 'USER0100', SYSDATE);
COMMIT;
INSERT INTO accounts VALUES (0101,0101, 10000, 'USER0101', SYSDATE);
INSERT INTO accounts VALUES (0102,0102, 10000, 'USER0102', SYSDATE);
INSERT INTO accounts VALUES (0103,0103, 10000, 'USER0103', SYSDATE);
INSERT INTO accounts VALUES (0104,0104, 10000, 'USER0104', SYSDATE);
INSERT INTO accounts VALUES (0105,0105, 10000, 'USER0105', SYSDATE);
INSERT INTO accounts VALUES (0106,0106, 10000, 'USER0106', SYSDATE);
INSERT INTO accounts VALUES (0107,0107, 10000, 'USER0107', SYSDATE);
INSERT INTO accounts VALUES (0108,0108, 10000, 'USER0108', SYSDATE);
INSERT INTO accounts VALUES (0109,0109, 10000, 'USER0109', SYSDATE);
INSERT INTO accounts VALUES (0110,0110, 10000, 'USER0110', SYSDATE);
INSERT INTO accounts VALUES (0111,0111, 10000, 'USER0111', SYSDATE);
INSERT INTO accounts VALUES (0112,0112, 10000, 'USER0112', SYSDATE);
INSERT INTO accounts VALUES (0113,0113, 10000, 'USER0113', SYSDATE);
INSERT INTO accounts VALUES (0114,0114, 10000, 'USER0114', SYSDATE);
INSERT INTO accounts VALUES (0115,0115, 10000, 'USER0115', SYSDATE);
INSERT INTO accounts VALUES (0116,0116, 10000, 'USER0116', SYSDATE);
INSERT INTO accounts VALUES (0117,0117, 10000, 'USER0117', SYSDATE);
INSERT INTO accounts VALUES (0118,0118, 10000, 'USER0118', SYSDATE);
INSERT INTO accounts VALUES (0119,0119, 10000, 'USER0119', SYSDATE);
INSERT INTO accounts VALUES (0120,0120, 10000, 'USER0120', SYSDATE);
INSERT INTO accounts VALUES (0121,0121, 10000, 'USER0121', SYSDATE);
INSERT INTO accounts VALUES (0122,0122, 10000, 'USER0122', SYSDATE);
INSERT INTO accounts VALUES (0123,0123, 10000, 'USER0123', SYSDATE);
INSERT INTO accounts VALUES (0124,0124, 10000, 'USER0124', SYSDATE);
INSERT INTO accounts VALUES (0125,0125, 10000, 'USER0125', SYSDATE);
INSERT INTO accounts VALUES (0126,0126, 10000, 'USER0126', SYSDATE);
INSERT INTO accounts VALUES (0127,0127, 10000, 'USER0127', SYSDATE);
INSERT INTO accounts VALUES (0128,0128, 10000, 'USER0128', SYSDATE);
INSERT INTO accounts VALUES (0129,0129, 10000, 'USER0129', SYSDATE);
INSERT INTO accounts VALUES (0130,0130, 10000, 'USER0130', SYSDATE);
INSERT INTO accounts VALUES (0131,0131, 10000, 'USER0131', SYSDATE);
INSERT INTO accounts VALUES (0132,0132, 10000, 'USER0132', SYSDATE);
INSERT INTO accounts VALUES (0133,0133, 10000, 'USER0133', SYSDATE);
INSERT INTO accounts VALUES (0134,0134, 10000, 'USER0134', SYSDATE);
INSERT INTO accounts VALUES (0135,0135, 10000, 'USER0135', SYSDATE);
INSERT INTO accounts VALUES (0136,0136, 10000, 'USER0136', SYSDATE);
INSERT INTO accounts VALUES (0137,0137, 10000, 'USER0137', SYSDATE);
INSERT INTO accounts VALUES (0138,0138, 10000, 'USER0138', SYSDATE);
INSERT INTO accounts VALUES (0139,0139, 10000, 'USER0139', SYSDATE);
INSERT INTO accounts VALUES (0140,0140, 10000, 'USER0140', SYSDATE);
INSERT INTO accounts VALUES (0141,0141, 10000, 'USER0141', SYSDATE);
INSERT INTO accounts VALUES (0142,0142, 10000, 'USER0142', SYSDATE);
INSERT INTO accounts VALUES (0143,0143, 10000, 'USER0143', SYSDATE);
INSERT INTO accounts VALUES (0144,0144, 10000, 'USER0144', SYSDATE);
INSERT INTO accounts VALUES (0145,0145, 10000, 'USER0145', SYSDATE);
INSERT INTO accounts VALUES (0146,0146, 10000, 'USER0146', SYSDATE);
INSERT INTO accounts VALUES (0147,0147, 10000, 'USER0147', SYSDATE);
INSERT INTO accounts VALUES (0148,0148, 10000, 'USER0148', SYSDATE);
INSERT INTO accounts VALUES (0149,0149, 10000, 'USER0149', SYSDATE);
INSERT INTO accounts VALUES (0150,0150, 10000, 'USER0150', SYSDATE);
INSERT INTO accounts VALUES (0151,0151, 10000, 'USER0151', SYSDATE);
INSERT INTO accounts VALUES (0152,0152, 10000, 'USER0152', SYSDATE);
INSERT INTO accounts VALUES (0153,0153, 10000, 'USER0153', SYSDATE);
INSERT INTO accounts VALUES (0154,0154, 10000, 'USER0154', SYSDATE);
INSERT INTO accounts VALUES (0155,0155, 10000, 'USER0155', SYSDATE);
INSERT INTO accounts VALUES (0156,0156, 10000, 'USER0156', SYSDATE);
INSERT INTO accounts VALUES (0157,0157, 10000, 'USER0157', SYSDATE);
INSERT INTO accounts VALUES (0158,0158, 10000, 'USER0158', SYSDATE);
INSERT INTO accounts VALUES (0159,0159, 10000, 'USER0159', SYSDATE);
INSERT INTO accounts VALUES (0160,0160, 10000, 'USER0160', SYSDATE);
INSERT INTO accounts VALUES (0161,0161, 10000, 'USER0161', SYSDATE);
INSERT INTO accounts VALUES (0162,0162, 10000, 'USER0162', SYSDATE);
INSERT INTO accounts VALUES (0163,0163, 10000, 'USER0163', SYSDATE);
INSERT INTO accounts VALUES (0164,0164, 10000, 'USER0164', SYSDATE);
INSERT INTO accounts VALUES (0165,0165, 10000, 'USER0165', SYSDATE);
INSERT INTO accounts VALUES (0166,0166, 10000, 'USER0166', SYSDATE);
INSERT INTO accounts VALUES (0167,0167, 10000, 'USER0167', SYSDATE);
INSERT INTO accounts VALUES (0168,0168, 10000, 'USER0168', SYSDATE);
INSERT INTO accounts VALUES (0169,0169, 10000, 'USER0169', SYSDATE);
INSERT INTO accounts VALUES (0170,0170, 10000, 'USER0170', SYSDATE);
INSERT INTO accounts VALUES (0171,0171, 10000, 'USER0171', SYSDATE);
INSERT INTO accounts VALUES (0172,0172, 10000, 'USER0172', SYSDATE);
INSERT INTO accounts VALUES (0173,0173, 10000, 'USER0173', SYSDATE);
INSERT INTO accounts VALUES (0174,0174, 10000, 'USER0174', SYSDATE);
INSERT INTO accounts VALUES (0175,0175, 10000, 'USER0175', SYSDATE);
INSERT INTO accounts VALUES (0176,0176, 10000, 'USER0176', SYSDATE);
INSERT INTO accounts VALUES (0177,0177, 10000, 'USER0177', SYSDATE);
INSERT INTO accounts VALUES (0178,0178, 10000, 'USER0178', SYSDATE);
INSERT INTO accounts VALUES (0179,0179, 10000, 'USER0179', SYSDATE);
INSERT INTO accounts VALUES (0180,0180, 10000, 'USER0180', SYSDATE);
INSERT INTO accounts VALUES (0181,0181, 10000, 'USER0181', SYSDATE);
INSERT INTO accounts VALUES (0182,0182, 10000, 'USER0182', SYSDATE);
INSERT INTO accounts VALUES (0183,0183, 10000, 'USER0183', SYSDATE);
INSERT INTO accounts VALUES (0184,0184, 10000, 'USER0184', SYSDATE);
INSERT INTO accounts VALUES (0185,0185, 10000, 'USER0185', SYSDATE);
INSERT INTO accounts VALUES (0186,0186, 10000, 'USER0186', SYSDATE);
INSERT INTO accounts VALUES (0187,0187, 10000, 'USER0187', SYSDATE);
INSERT INTO accounts VALUES (0188,0188, 10000, 'USER0188', SYSDATE);
INSERT INTO accounts VALUES (0189,0189, 10000, 'USER0189', SYSDATE);
INSERT INTO accounts VALUES (0190,0190, 10000, 'USER0190', SYSDATE);
INSERT INTO accounts VALUES (0191,0191, 10000, 'USER0191', SYSDATE);
INSERT INTO accounts VALUES (0192,0192, 10000, 'USER0192', SYSDATE);
INSERT INTO accounts VALUES (0193,0193, 10000, 'USER0193', SYSDATE);
INSERT INTO accounts VALUES (0194,0194, 10000, 'USER0194', SYSDATE);
INSERT INTO accounts VALUES (0195,0195, 10000, 'USER0195', SYSDATE);
INSERT INTO accounts VALUES (0196,0196, 10000, 'USER0196', SYSDATE);
INSERT INTO accounts VALUES (0197,0197, 10000, 'USER0197', SYSDATE);
INSERT INTO accounts VALUES (0198,0198, 10000, 'USER0198', SYSDATE);
INSERT INTO accounts VALUES (0199,0199, 10000, 'USER0199', SYSDATE);
INSERT INTO accounts VALUES (0200,0200, 10000, 'USER0200', SYSDATE);
COMMIT;
INSERT INTO accounts VALUES (0201,0201, 10000, 'USER0201', SYSDATE);
INSERT INTO accounts VALUES (0202,0202, 10000, 'USER0202', SYSDATE);
INSERT INTO accounts VALUES (0203,0203, 10000, 'USER0203', SYSDATE);
INSERT INTO accounts VALUES (0204,0204, 10000, 'USER0204', SYSDATE);
INSERT INTO accounts VALUES (0205,0205, 10000, 'USER0205', SYSDATE);
INSERT INTO accounts VALUES (0206,0206, 10000, 'USER0206', SYSDATE);
INSERT INTO accounts VALUES (0207,0207, 10000, 'USER0207', SYSDATE);
INSERT INTO accounts VALUES (0208,0208, 10000, 'USER0208', SYSDATE);
INSERT INTO accounts VALUES (0209,0209, 10000, 'USER0209', SYSDATE);
INSERT INTO accounts VALUES (0210,0210, 10000, 'USER0210', SYSDATE);
INSERT INTO accounts VALUES (0211,0211, 10000, 'USER0211', SYSDATE);
INSERT INTO accounts VALUES (0212,0212, 10000, 'USER0212', SYSDATE);
INSERT INTO accounts VALUES (0213,0213, 10000, 'USER0213', SYSDATE);
INSERT INTO accounts VALUES (0214,0214, 10000, 'USER0214', SYSDATE);
INSERT INTO accounts VALUES (0215,0215, 10000, 'USER0215', SYSDATE);
INSERT INTO accounts VALUES (0216,0216, 10000, 'USER0216', SYSDATE);
INSERT INTO accounts VALUES (0217,0217, 10000, 'USER0217', SYSDATE);
INSERT INTO accounts VALUES (0218,0218, 10000, 'USER0218', SYSDATE);
INSERT INTO accounts VALUES (0219,0219, 10000, 'USER0219', SYSDATE);
INSERT INTO accounts VALUES (0220,0220, 10000, 'USER0220', SYSDATE);
INSERT INTO accounts VALUES (0221,0221, 10000, 'USER0221', SYSDATE);
INSERT INTO accounts VALUES (0222,0222, 10000, 'USER0222', SYSDATE);
INSERT INTO accounts VALUES (0223,0223, 10000, 'USER0223', SYSDATE);
INSERT INTO accounts VALUES (0224,0224, 10000, 'USER0224', SYSDATE);
INSERT INTO accounts VALUES (0225,0225, 10000, 'USER0225', SYSDATE);
INSERT INTO accounts VALUES (0226,0226, 10000, 'USER0226', SYSDATE);
INSERT INTO accounts VALUES (0227,0227, 10000, 'USER0227', SYSDATE);
INSERT INTO accounts VALUES (0228,0228, 10000, 'USER0228', SYSDATE);
INSERT INTO accounts VALUES (0229,0229, 10000, 'USER0229', SYSDATE);
INSERT INTO accounts VALUES (0230,0230, 10000, 'USER0230', SYSDATE);
INSERT INTO accounts VALUES (0231,0231, 10000, 'USER0231', SYSDATE);
INSERT INTO accounts VALUES (0232,0232, 10000, 'USER0232', SYSDATE);
INSERT INTO accounts VALUES (0233,0233, 10000, 'USER0233', SYSDATE);
INSERT INTO accounts VALUES (0234,0234, 10000, 'USER0234', SYSDATE);
INSERT INTO accounts VALUES (0235,0235, 10000, 'USER0235', SYSDATE);
INSERT INTO accounts VALUES (0236,0236, 10000, 'USER0236', SYSDATE);
INSERT INTO accounts VALUES (0237,0237, 10000, 'USER0237', SYSDATE);
INSERT INTO accounts VALUES (0238,0238, 10000, 'USER0238', SYSDATE);
INSERT INTO accounts VALUES (0239,0239, 10000, 'USER0239', SYSDATE);
INSERT INTO accounts VALUES (0240,0240, 10000, 'USER0240', SYSDATE);
INSERT INTO accounts VALUES (0241,0241, 10000, 'USER0241', SYSDATE);
INSERT INTO accounts VALUES (0242,0242, 10000, 'USER0242', SYSDATE);
INSERT INTO accounts VALUES (0243,0243, 10000, 'USER0243', SYSDATE);
INSERT INTO accounts VALUES (0244,0244, 10000, 'USER0244', SYSDATE);
INSERT INTO accounts VALUES (0245,0245, 10000, 'USER0245', SYSDATE);
INSERT INTO accounts VALUES (0246,0246, 10000, 'USER0246', SYSDATE);
INSERT INTO accounts VALUES (0247,0247, 10000, 'USER0247', SYSDATE);
INSERT INTO accounts VALUES (0248,0248, 10000, 'USER0248', SYSDATE);
INSERT INTO accounts VALUES (0249,0249, 10000, 'USER0249', SYSDATE);
INSERT INTO accounts VALUES (0250,0250, 10000, 'USER0250', SYSDATE);
INSERT INTO accounts VALUES (0251,0251, 10000, 'USER0251', SYSDATE);
INSERT INTO accounts VALUES (0252,0252, 10000, 'USER0252', SYSDATE);
INSERT INTO accounts VALUES (0253,0253, 10000, 'USER0253', SYSDATE);
INSERT INTO accounts VALUES (0254,0254, 10000, 'USER0254', SYSDATE);
INSERT INTO accounts VALUES (0255,0255, 10000, 'USER0255', SYSDATE);
INSERT INTO accounts VALUES (0256,0256, 10000, 'USER0256', SYSDATE);
INSERT INTO accounts VALUES (0257,0257, 10000, 'USER0257', SYSDATE);
INSERT INTO accounts VALUES (0258,0258, 10000, 'USER0258', SYSDATE);
INSERT INTO accounts VALUES (0259,0259, 10000, 'USER0259', SYSDATE);
INSERT INTO accounts VALUES (0260,0260, 10000, 'USER0260', SYSDATE);
INSERT INTO accounts VALUES (0261,0261, 10000, 'USER0261', SYSDATE);
INSERT INTO accounts VALUES (0262,0262, 10000, 'USER0262', SYSDATE);
INSERT INTO accounts VALUES (0263,0263, 10000, 'USER0263', SYSDATE);
INSERT INTO accounts VALUES (0264,0264, 10000, 'USER0264', SYSDATE);
INSERT INTO accounts VALUES (0265,0265, 10000, 'USER0265', SYSDATE);
INSERT INTO accounts VALUES (0266,0266, 10000, 'USER0266', SYSDATE);
INSERT INTO accounts VALUES (0267,0267, 10000, 'USER0267', SYSDATE);
INSERT INTO accounts VALUES (0268,0268, 10000, 'USER0268', SYSDATE);
INSERT INTO accounts VALUES (0269,0269, 10000, 'USER0269', SYSDATE);
INSERT INTO accounts VALUES (0270,0270, 10000, 'USER0270', SYSDATE);
INSERT INTO accounts VALUES (0271,0271, 10000, 'USER0271', SYSDATE);
INSERT INTO accounts VALUES (0272,0272, 10000, 'USER0272', SYSDATE);
INSERT INTO accounts VALUES (0273,0273, 10000, 'USER0273', SYSDATE);
INSERT INTO accounts VALUES (0274,0274, 10000, 'USER0274', SYSDATE);
INSERT INTO accounts VALUES (0275,0275, 10000, 'USER0275', SYSDATE);
INSERT INTO accounts VALUES (0276,0276, 10000, 'USER0276', SYSDATE);
INSERT INTO accounts VALUES (0277,0277, 10000, 'USER0277', SYSDATE);
INSERT INTO accounts VALUES (0278,0278, 10000, 'USER0278', SYSDATE);
INSERT INTO accounts VALUES (0279,0279, 10000, 'USER0279', SYSDATE);
INSERT INTO accounts VALUES (0280,0280, 10000, 'USER0280', SYSDATE);
INSERT INTO accounts VALUES (0281,0281, 10000, 'USER0281', SYSDATE);
INSERT INTO accounts VALUES (0282,0282, 10000, 'USER0282', SYSDATE);
INSERT INTO accounts VALUES (0283,0283, 10000, 'USER0283', SYSDATE);
INSERT INTO accounts VALUES (0284,0284, 10000, 'USER0284', SYSDATE);
INSERT INTO accounts VALUES (0285,0285, 10000, 'USER0285', SYSDATE);
INSERT INTO accounts VALUES (0286,0286, 10000, 'USER0286', SYSDATE);
INSERT INTO accounts VALUES (0287,0287, 10000, 'USER0287', SYSDATE);
INSERT INTO accounts VALUES (0288,0288, 10000, 'USER0288', SYSDATE);
INSERT INTO accounts VALUES (0289,0289, 10000, 'USER0289', SYSDATE);
INSERT INTO accounts VALUES (0290,0290, 10000, 'USER0290', SYSDATE);
INSERT INTO accounts VALUES (0291,0291, 10000, 'USER0291', SYSDATE);
INSERT INTO accounts VALUES (0292,0292, 10000, 'USER0292', SYSDATE);
INSERT INTO accounts VALUES (0293,0293, 10000, 'USER0293', SYSDATE);
INSERT INTO accounts VALUES (0294,0294, 10000, 'USER0294', SYSDATE);
INSERT INTO accounts VALUES (0295,0295, 10000, 'USER0295', SYSDATE);
INSERT INTO accounts VALUES (0296,0296, 10000, 'USER0296', SYSDATE);
INSERT INTO accounts VALUES (0297,0297, 10000, 'USER0297', SYSDATE);
INSERT INTO accounts VALUES (0298,0298, 10000, 'USER0298', SYSDATE);
INSERT INTO accounts VALUES (0299,0299, 10000, 'USER0299', SYSDATE);
INSERT INTO accounts VALUES (0300,0300, 10000, 'USER0300', SYSDATE);
COMMIT;
INSERT INTO accounts VALUES (0301,0301, 10000, 'USER0301', SYSDATE);
INSERT INTO accounts VALUES (0302,0302, 10000, 'USER0302', SYSDATE);
INSERT INTO accounts VALUES (0303,0303, 10000, 'USER0303', SYSDATE);
INSERT INTO accounts VALUES (0304,0304, 10000, 'USER0304', SYSDATE);
INSERT INTO accounts VALUES (0305,0305, 10000, 'USER0305', SYSDATE);
INSERT INTO accounts VALUES (0306,0306, 10000, 'USER0306', SYSDATE);
INSERT INTO accounts VALUES (0307,0307, 10000, 'USER0307', SYSDATE);
INSERT INTO accounts VALUES (0308,0308, 10000, 'USER0308', SYSDATE);
INSERT INTO accounts VALUES (0309,0309, 10000, 'USER0309', SYSDATE);
INSERT INTO accounts VALUES (0310,0310, 10000, 'USER0310', SYSDATE);
INSERT INTO accounts VALUES (0311,0311, 10000, 'USER0311', SYSDATE);
INSERT INTO accounts VALUES (0312,0312, 10000, 'USER0312', SYSDATE);
INSERT INTO accounts VALUES (0313,0313, 10000, 'USER0313', SYSDATE);
INSERT INTO accounts VALUES (0314,0314, 10000, 'USER0314', SYSDATE);
INSERT INTO accounts VALUES (0315,0315, 10000, 'USER0315', SYSDATE);
INSERT INTO accounts VALUES (0316,0316, 10000, 'USER0316', SYSDATE);
INSERT INTO accounts VALUES (0317,0317, 10000, 'USER0317', SYSDATE);
INSERT INTO accounts VALUES (0318,0318, 10000, 'USER0318', SYSDATE);
INSERT INTO accounts VALUES (0319,0319, 10000, 'USER0319', SYSDATE);
INSERT INTO accounts VALUES (0320,0320, 10000, 'USER0320', SYSDATE);
INSERT INTO accounts VALUES (0321,0321, 10000, 'USER0321', SYSDATE);
INSERT INTO accounts VALUES (0322,0322, 10000, 'USER0322', SYSDATE);
INSERT INTO accounts VALUES (0323,0323, 10000, 'USER0323', SYSDATE);
INSERT INTO accounts VALUES (0324,0324, 10000, 'USER0324', SYSDATE);
INSERT INTO accounts VALUES (0325,0325, 10000, 'USER0325', SYSDATE);
INSERT INTO accounts VALUES (0326,0326, 10000, 'USER0326', SYSDATE);
INSERT INTO accounts VALUES (0327,0327, 10000, 'USER0327', SYSDATE);
INSERT INTO accounts VALUES (0328,0328, 10000, 'USER0328', SYSDATE);
INSERT INTO accounts VALUES (0329,0329, 10000, 'USER0329', SYSDATE);
INSERT INTO accounts VALUES (0330,0330, 10000, 'USER0330', SYSDATE);
INSERT INTO accounts VALUES (0331,0331, 10000, 'USER0331', SYSDATE);
INSERT INTO accounts VALUES (0332,0332, 10000, 'USER0332', SYSDATE);
INSERT INTO accounts VALUES (0333,0333, 10000, 'USER0333', SYSDATE);
INSERT INTO accounts VALUES (0334,0334, 10000, 'USER0334', SYSDATE);
INSERT INTO accounts VALUES (0335,0335, 10000, 'USER0335', SYSDATE);
INSERT INTO accounts VALUES (0336,0336, 10000, 'USER0336', SYSDATE);
INSERT INTO accounts VALUES (0337,0337, 10000, 'USER0337', SYSDATE);
INSERT INTO accounts VALUES (0338,0338, 10000, 'USER0338', SYSDATE);
INSERT INTO accounts VALUES (0339,0339, 10000, 'USER0339', SYSDATE);
INSERT INTO accounts VALUES (0340,0340, 10000, 'USER0340', SYSDATE);
INSERT INTO accounts VALUES (0341,0341, 10000, 'USER0341', SYSDATE);
INSERT INTO accounts VALUES (0342,0342, 10000, 'USER0342', SYSDATE);
INSERT INTO accounts VALUES (0343,0343, 10000, 'USER0343', SYSDATE);
INSERT INTO accounts VALUES (0344,0344, 10000, 'USER0344', SYSDATE);
INSERT INTO accounts VALUES (0345,0345, 10000, 'USER0345', SYSDATE);
INSERT INTO accounts VALUES (0346,0346, 10000, 'USER0346', SYSDATE);
INSERT INTO accounts VALUES (0347,0347, 10000, 'USER0347', SYSDATE);
INSERT INTO accounts VALUES (0348,0348, 10000, 'USER0348', SYSDATE);
INSERT INTO accounts VALUES (0349,0349, 10000, 'USER0349', SYSDATE);
INSERT INTO accounts VALUES (0350,0350, 10000, 'USER0350', SYSDATE);
INSERT INTO accounts VALUES (0351,0351, 10000, 'USER0351', SYSDATE);
INSERT INTO accounts VALUES (0352,0352, 10000, 'USER0352', SYSDATE);
INSERT INTO accounts VALUES (0353,0353, 10000, 'USER0353', SYSDATE);
INSERT INTO accounts VALUES (0354,0354, 10000, 'USER0354', SYSDATE);
INSERT INTO accounts VALUES (0355,0355, 10000, 'USER0355', SYSDATE);
INSERT INTO accounts VALUES (0356,0356, 10000, 'USER0356', SYSDATE);
INSERT INTO accounts VALUES (0357,0357, 10000, 'USER0357', SYSDATE);
INSERT INTO accounts VALUES (0358,0358, 10000, 'USER0358', SYSDATE);
INSERT INTO accounts VALUES (0359,0359, 10000, 'USER0359', SYSDATE);
INSERT INTO accounts VALUES (0360,0360, 10000, 'USER0360', SYSDATE);
INSERT INTO accounts VALUES (0361,0361, 10000, 'USER0361', SYSDATE);
INSERT INTO accounts VALUES (0362,0362, 10000, 'USER0362', SYSDATE);
INSERT INTO accounts VALUES (0363,0363, 10000, 'USER0363', SYSDATE);
INSERT INTO accounts VALUES (0364,0364, 10000, 'USER0364', SYSDATE);
INSERT INTO accounts VALUES (0365,0365, 10000, 'USER0365', SYSDATE);
INSERT INTO accounts VALUES (0366,0366, 10000, 'USER0366', SYSDATE);
INSERT INTO accounts VALUES (0367,0367, 10000, 'USER0367', SYSDATE);
INSERT INTO accounts VALUES (0368,0368, 10000, 'USER0368', SYSDATE);
INSERT INTO accounts VALUES (0369,0369, 10000, 'USER0369', SYSDATE);
INSERT INTO accounts VALUES (0370,0370, 10000, 'USER0370', SYSDATE);
INSERT INTO accounts VALUES (0371,0371, 10000, 'USER0371', SYSDATE);
INSERT INTO accounts VALUES (0372,0372, 10000, 'USER0372', SYSDATE);
INSERT INTO accounts VALUES (0373,0373, 10000, 'USER0373', SYSDATE);
INSERT INTO accounts VALUES (0374,0374, 10000, 'USER0374', SYSDATE);
INSERT INTO accounts VALUES (0375,0375, 10000, 'USER0375', SYSDATE);
INSERT INTO accounts VALUES (0376,0376, 10000, 'USER0376', SYSDATE);
INSERT INTO accounts VALUES (0377,0377, 10000, 'USER0377', SYSDATE);
INSERT INTO accounts VALUES (0378,0378, 10000, 'USER0378', SYSDATE);
INSERT INTO accounts VALUES (0379,0379, 10000, 'USER0379', SYSDATE);
INSERT INTO accounts VALUES (0380,0380, 10000, 'USER0380', SYSDATE);
INSERT INTO accounts VALUES (0381,0381, 10000, 'USER0381', SYSDATE);
INSERT INTO accounts VALUES (0382,0382, 10000, 'USER0382', SYSDATE);
INSERT INTO accounts VALUES (0383,0383, 10000, 'USER0383', SYSDATE);
INSERT INTO accounts VALUES (0384,0384, 10000, 'USER0384', SYSDATE);
INSERT INTO accounts VALUES (0385,0385, 10000, 'USER0385', SYSDATE);
INSERT INTO accounts VALUES (0386,0386, 10000, 'USER0386', SYSDATE);
INSERT INTO accounts VALUES (0387,0387, 10000, 'USER0387', SYSDATE);
INSERT INTO accounts VALUES (0388,0388, 10000, 'USER0388', SYSDATE);
INSERT INTO accounts VALUES (0389,0389, 10000, 'USER0389', SYSDATE);
INSERT INTO accounts VALUES (0390,0390, 10000, 'USER0390', SYSDATE);
INSERT INTO accounts VALUES (0391,0391, 10000, 'USER0391', SYSDATE);
INSERT INTO accounts VALUES (0392,0392, 10000, 'USER0392', SYSDATE);
INSERT INTO accounts VALUES (0393,0393, 10000, 'USER0393', SYSDATE);
INSERT INTO accounts VALUES (0394,0394, 10000, 'USER0394', SYSDATE);
INSERT INTO accounts VALUES (0395,0395, 10000, 'USER0395', SYSDATE);
INSERT INTO accounts VALUES (0396,0396, 10000, 'USER0396', SYSDATE);
INSERT INTO accounts VALUES (0397,0397, 10000, 'USER0397', SYSDATE);
INSERT INTO accounts VALUES (0398,0398, 10000, 'USER0398', SYSDATE);
INSERT INTO accounts VALUES (0399,0399, 10000, 'USER0399', SYSDATE);
INSERT INTO accounts VALUES (0400,0400, 10000, 'USER0400', SYSDATE);
COMMIT;
INSERT INTO accounts VALUES (0401,0401, 10000, 'USER0401', SYSDATE);
INSERT INTO accounts VALUES (0402,0402, 10000, 'USER0402', SYSDATE);
INSERT INTO accounts VALUES (0403,0403, 10000, 'USER0403', SYSDATE);
INSERT INTO accounts VALUES (0404,0404, 10000, 'USER0404', SYSDATE);
INSERT INTO accounts VALUES (0405,0405, 10000, 'USER0405', SYSDATE);
INSERT INTO accounts VALUES (0406,0406, 10000, 'USER0406', SYSDATE);
INSERT INTO accounts VALUES (0407,0407, 10000, 'USER0407', SYSDATE);
INSERT INTO accounts VALUES (0408,0408, 10000, 'USER0408', SYSDATE);
INSERT INTO accounts VALUES (0409,0409, 10000, 'USER0409', SYSDATE);
INSERT INTO accounts VALUES (0410,0410, 10000, 'USER0410', SYSDATE);
INSERT INTO accounts VALUES (0411,0411, 10000, 'USER0411', SYSDATE);
INSERT INTO accounts VALUES (0412,0412, 10000, 'USER0412', SYSDATE);
INSERT INTO accounts VALUES (0413,0413, 10000, 'USER0413', SYSDATE);
INSERT INTO accounts VALUES (0414,0414, 10000, 'USER0414', SYSDATE);
INSERT INTO accounts VALUES (0415,0415, 10000, 'USER0415', SYSDATE);
INSERT INTO accounts VALUES (0416,0416, 10000, 'USER0416', SYSDATE);
INSERT INTO accounts VALUES (0417,0417, 10000, 'USER0417', SYSDATE);
INSERT INTO accounts VALUES (0418,0418, 10000, 'USER0418', SYSDATE);
INSERT INTO accounts VALUES (0419,0419, 10000, 'USER0419', SYSDATE);
INSERT INTO accounts VALUES (0420,0420, 10000, 'USER0420', SYSDATE);
INSERT INTO accounts VALUES (0421,0421, 10000, 'USER0421', SYSDATE);
INSERT INTO accounts VALUES (0422,0422, 10000, 'USER0422', SYSDATE);
INSERT INTO accounts VALUES (0423,0423, 10000, 'USER0423', SYSDATE);
INSERT INTO accounts VALUES (0424,0424, 10000, 'USER0424', SYSDATE);
INSERT INTO accounts VALUES (0425,0425, 10000, 'USER0425', SYSDATE);
INSERT INTO accounts VALUES (0426,0426, 10000, 'USER0426', SYSDATE);
INSERT INTO accounts VALUES (0427,0427, 10000, 'USER0427', SYSDATE);
INSERT INTO accounts VALUES (0428,0428, 10000, 'USER0428', SYSDATE);
INSERT INTO accounts VALUES (0429,0429, 10000, 'USER0429', SYSDATE);
INSERT INTO accounts VALUES (0430,0430, 10000, 'USER0430', SYSDATE);
INSERT INTO accounts VALUES (0431,0431, 10000, 'USER0431', SYSDATE);
INSERT INTO accounts VALUES (0432,0432, 10000, 'USER0432', SYSDATE);
INSERT INTO accounts VALUES (0433,0433, 10000, 'USER0433', SYSDATE);
INSERT INTO accounts VALUES (0434,0434, 10000, 'USER0434', SYSDATE);
INSERT INTO accounts VALUES (0435,0435, 10000, 'USER0435', SYSDATE);
INSERT INTO accounts VALUES (0436,0436, 10000, 'USER0436', SYSDATE);
INSERT INTO accounts VALUES (0437,0437, 10000, 'USER0437', SYSDATE);
INSERT INTO accounts VALUES (0438,0438, 10000, 'USER0438', SYSDATE);
INSERT INTO accounts VALUES (0439,0439, 10000, 'USER0439', SYSDATE);
INSERT INTO accounts VALUES (0440,0440, 10000, 'USER0440', SYSDATE);
INSERT INTO accounts VALUES (0441,0441, 10000, 'USER0441', SYSDATE);
INSERT INTO accounts VALUES (0442,0442, 10000, 'USER0442', SYSDATE);
INSERT INTO accounts VALUES (0443,0443, 10000, 'USER0443', SYSDATE);
INSERT INTO accounts VALUES (0444,0444, 10000, 'USER0444', SYSDATE);
INSERT INTO accounts VALUES (0445,0445, 10000, 'USER0445', SYSDATE);
INSERT INTO accounts VALUES (0446,0446, 10000, 'USER0446', SYSDATE);
INSERT INTO accounts VALUES (0447,0447, 10000, 'USER0447', SYSDATE);
INSERT INTO accounts VALUES (0448,0448, 10000, 'USER0448', SYSDATE);
INSERT INTO accounts VALUES (0449,0449, 10000, 'USER0449', SYSDATE);
INSERT INTO accounts VALUES (0450,0450, 10000, 'USER0450', SYSDATE);
INSERT INTO accounts VALUES (0451,0451, 10000, 'USER0451', SYSDATE);
INSERT INTO accounts VALUES (0452,0452, 10000, 'USER0452', SYSDATE);
INSERT INTO accounts VALUES (0453,0453, 10000, 'USER0453', SYSDATE);
INSERT INTO accounts VALUES (0454,0454, 10000, 'USER0454', SYSDATE);
INSERT INTO accounts VALUES (0455,0455, 10000, 'USER0455', SYSDATE);
INSERT INTO accounts VALUES (0456,0456, 10000, 'USER0456', SYSDATE);
INSERT INTO accounts VALUES (0457,0457, 10000, 'USER0457', SYSDATE);
INSERT INTO accounts VALUES (0458,0458, 10000, 'USER0458', SYSDATE);
INSERT INTO accounts VALUES (0459,0459, 10000, 'USER0459', SYSDATE);
INSERT INTO accounts VALUES (0460,0460, 10000, 'USER0460', SYSDATE);
INSERT INTO accounts VALUES (0461,0461, 10000, 'USER0461', SYSDATE);
INSERT INTO accounts VALUES (0462,0462, 10000, 'USER0462', SYSDATE);
INSERT INTO accounts VALUES (0463,0463, 10000, 'USER0463', SYSDATE);
INSERT INTO accounts VALUES (0464,0464, 10000, 'USER0464', SYSDATE);
INSERT INTO accounts VALUES (0465,0465, 10000, 'USER0465', SYSDATE);
INSERT INTO accounts VALUES (0466,0466, 10000, 'USER0466', SYSDATE);
INSERT INTO accounts VALUES (0467,0467, 10000, 'USER0467', SYSDATE);
INSERT INTO accounts VALUES (0468,0468, 10000, 'USER0468', SYSDATE);
INSERT INTO accounts VALUES (0469,0469, 10000, 'USER0469', SYSDATE);
INSERT INTO accounts VALUES (0470,0470, 10000, 'USER0470', SYSDATE);
INSERT INTO accounts VALUES (0471,0471, 10000, 'USER0471', SYSDATE);
INSERT INTO accounts VALUES (0472,0472, 10000, 'USER0472', SYSDATE);
INSERT INTO accounts VALUES (0473,0473, 10000, 'USER0473', SYSDATE);
INSERT INTO accounts VALUES (0474,0474, 10000, 'USER0474', SYSDATE);
INSERT INTO accounts VALUES (0475,0475, 10000, 'USER0475', SYSDATE);
INSERT INTO accounts VALUES (0476,0476, 10000, 'USER0476', SYSDATE);
INSERT INTO accounts VALUES (0477,0477, 10000, 'USER0477', SYSDATE);
INSERT INTO accounts VALUES (0478,0478, 10000, 'USER0478', SYSDATE);
INSERT INTO accounts VALUES (0479,0479, 10000, 'USER0479', SYSDATE);
INSERT INTO accounts VALUES (0480,0480, 10000, 'USER0480', SYSDATE);
INSERT INTO accounts VALUES (0481,0481, 10000, 'USER0481', SYSDATE);
INSERT INTO accounts VALUES (0482,0482, 10000, 'USER0482', SYSDATE);
INSERT INTO accounts VALUES (0483,0483, 10000, 'USER0483', SYSDATE);
INSERT INTO accounts VALUES (0484,0484, 10000, 'USER0484', SYSDATE);
INSERT INTO accounts VALUES (0485,0485, 10000, 'USER0485', SYSDATE);
INSERT INTO accounts VALUES (0486,0486, 10000, 'USER0486', SYSDATE);
INSERT INTO accounts VALUES (0487,0487, 10000, 'USER0487', SYSDATE);
INSERT INTO accounts VALUES (0488,0488, 10000, 'USER0488', SYSDATE);
INSERT INTO accounts VALUES (0489,0489, 10000, 'USER0489', SYSDATE);
INSERT INTO accounts VALUES (0490,0490, 10000, 'USER0490', SYSDATE);
INSERT INTO accounts VALUES (0491,0491, 10000, 'USER0491', SYSDATE);
INSERT INTO accounts VALUES (0492,0492, 10000, 'USER0492', SYSDATE);
INSERT INTO accounts VALUES (0493,0493, 10000, 'USER0493', SYSDATE);
INSERT INTO accounts VALUES (0494,0494, 10000, 'USER0494', SYSDATE);
INSERT INTO accounts VALUES (0495,0495, 10000, 'USER0495', SYSDATE);
INSERT INTO accounts VALUES (0496,0496, 10000, 'USER0496', SYSDATE);
INSERT INTO accounts VALUES (0497,0497, 10000, 'USER0497', SYSDATE);
INSERT INTO accounts VALUES (0498,0498, 10000, 'USER0498', SYSDATE);
INSERT INTO accounts VALUES (0499,0499, 10000, 'USER0499', SYSDATE);
INSERT INTO accounts VALUES (0500,0500, 10000, 'USER0500', SYSDATE);
COMMIT;
INSERT INTO accounts VALUES (0501,0501, 10000, 'USER0501', SYSDATE);
INSERT INTO accounts VALUES (0502,0502, 10000, 'USER0502', SYSDATE);
INSERT INTO accounts VALUES (0503,0503, 10000, 'USER0503', SYSDATE);
INSERT INTO accounts VALUES (0504,0504, 10000, 'USER0504', SYSDATE);
INSERT INTO accounts VALUES (0505,0505, 10000, 'USER0505', SYSDATE);
INSERT INTO accounts VALUES (0506,0506, 10000, 'USER0506', SYSDATE);
INSERT INTO accounts VALUES (0507,0507, 10000, 'USER0507', SYSDATE);
INSERT INTO accounts VALUES (0508,0508, 10000, 'USER0508', SYSDATE);
INSERT INTO accounts VALUES (0509,0509, 10000, 'USER0509', SYSDATE);
INSERT INTO accounts VALUES (0510,0510, 10000, 'USER0510', SYSDATE);
INSERT INTO accounts VALUES (0511,0511, 10000, 'USER0511', SYSDATE);
INSERT INTO accounts VALUES (0512,0512, 10000, 'USER0512', SYSDATE);
INSERT INTO accounts VALUES (0513,0513, 10000, 'USER0513', SYSDATE);
INSERT INTO accounts VALUES (0514,0514, 10000, 'USER0514', SYSDATE);
INSERT INTO accounts VALUES (0515,0515, 10000, 'USER0515', SYSDATE);
INSERT INTO accounts VALUES (0516,0516, 10000, 'USER0516', SYSDATE);
INSERT INTO accounts VALUES (0517,0517, 10000, 'USER0517', SYSDATE);
INSERT INTO accounts VALUES (0518,0518, 10000, 'USER0518', SYSDATE);
INSERT INTO accounts VALUES (0519,0519, 10000, 'USER0519', SYSDATE);
INSERT INTO accounts VALUES (0520,0520, 10000, 'USER0520', SYSDATE);
INSERT INTO accounts VALUES (0521,0521, 10000, 'USER0521', SYSDATE);
INSERT INTO accounts VALUES (0522,0522, 10000, 'USER0522', SYSDATE);
INSERT INTO accounts VALUES (0523,0523, 10000, 'USER0523', SYSDATE);
INSERT INTO accounts VALUES (0524,0524, 10000, 'USER0524', SYSDATE);
INSERT INTO accounts VALUES (0525,0525, 10000, 'USER0525', SYSDATE);
INSERT INTO accounts VALUES (0526,0526, 10000, 'USER0526', SYSDATE);
INSERT INTO accounts VALUES (0527,0527, 10000, 'USER0527', SYSDATE);
INSERT INTO accounts VALUES (0528,0528, 10000, 'USER0528', SYSDATE);
INSERT INTO accounts VALUES (0529,0529, 10000, 'USER0529', SYSDATE);
INSERT INTO accounts VALUES (0530,0530, 10000, 'USER0530', SYSDATE);
INSERT INTO accounts VALUES (0531,0531, 10000, 'USER0531', SYSDATE);
INSERT INTO accounts VALUES (0532,0532, 10000, 'USER0532', SYSDATE);
INSERT INTO accounts VALUES (0533,0533, 10000, 'USER0533', SYSDATE);
INSERT INTO accounts VALUES (0534,0534, 10000, 'USER0534', SYSDATE);
INSERT INTO accounts VALUES (0535,0535, 10000, 'USER0535', SYSDATE);
INSERT INTO accounts VALUES (0536,0536, 10000, 'USER0536', SYSDATE);
INSERT INTO accounts VALUES (0537,0537, 10000, 'USER0537', SYSDATE);
INSERT INTO accounts VALUES (0538,0538, 10000, 'USER0538', SYSDATE);
INSERT INTO accounts VALUES (0539,0539, 10000, 'USER0539', SYSDATE);
INSERT INTO accounts VALUES (0540,0540, 10000, 'USER0540', SYSDATE);
INSERT INTO accounts VALUES (0541,0541, 10000, 'USER0541', SYSDATE);
INSERT INTO accounts VALUES (0542,0542, 10000, 'USER0542', SYSDATE);
INSERT INTO accounts VALUES (0543,0543, 10000, 'USER0543', SYSDATE);
INSERT INTO accounts VALUES (0544,0544, 10000, 'USER0544', SYSDATE);
INSERT INTO accounts VALUES (0545,0545, 10000, 'USER0545', SYSDATE);
INSERT INTO accounts VALUES (0546,0546, 10000, 'USER0546', SYSDATE);
INSERT INTO accounts VALUES (0547,0547, 10000, 'USER0547', SYSDATE);
INSERT INTO accounts VALUES (0548,0548, 10000, 'USER0548', SYSDATE);
INSERT INTO accounts VALUES (0549,0549, 10000, 'USER0549', SYSDATE);
INSERT INTO accounts VALUES (0550,0550, 10000, 'USER0550', SYSDATE);
INSERT INTO accounts VALUES (0551,0551, 10000, 'USER0551', SYSDATE);
INSERT INTO accounts VALUES (0552,0552, 10000, 'USER0552', SYSDATE);
INSERT INTO accounts VALUES (0553,0553, 10000, 'USER0553', SYSDATE);
INSERT INTO accounts VALUES (0554,0554, 10000, 'USER0554', SYSDATE);
INSERT INTO accounts VALUES (0555,0555, 10000, 'USER0555', SYSDATE);
INSERT INTO accounts VALUES (0556,0556, 10000, 'USER0556', SYSDATE);
INSERT INTO accounts VALUES (0557,0557, 10000, 'USER0557', SYSDATE);
INSERT INTO accounts VALUES (0558,0558, 10000, 'USER0558', SYSDATE);
INSERT INTO accounts VALUES (0559,0559, 10000, 'USER0559', SYSDATE);
INSERT INTO accounts VALUES (0560,0560, 10000, 'USER0560', SYSDATE);
INSERT INTO accounts VALUES (0561,0561, 10000, 'USER0561', SYSDATE);
INSERT INTO accounts VALUES (0562,0562, 10000, 'USER0562', SYSDATE);
INSERT INTO accounts VALUES (0563,0563, 10000, 'USER0563', SYSDATE);
INSERT INTO accounts VALUES (0564,0564, 10000, 'USER0564', SYSDATE);
INSERT INTO accounts VALUES (0565,0565, 10000, 'USER0565', SYSDATE);
INSERT INTO accounts VALUES (0566,0566, 10000, 'USER0566', SYSDATE);
INSERT INTO accounts VALUES (0567,0567, 10000, 'USER0567', SYSDATE);
INSERT INTO accounts VALUES (0568,0568, 10000, 'USER0568', SYSDATE);
INSERT INTO accounts VALUES (0569,0569, 10000, 'USER0569', SYSDATE);
INSERT INTO accounts VALUES (0570,0570, 10000, 'USER0570', SYSDATE);
INSERT INTO accounts VALUES (0571,0571, 10000, 'USER0571', SYSDATE);
INSERT INTO accounts VALUES (0572,0572, 10000, 'USER0572', SYSDATE);
INSERT INTO accounts VALUES (0573,0573, 10000, 'USER0573', SYSDATE);
INSERT INTO accounts VALUES (0574,0574, 10000, 'USER0574', SYSDATE);
INSERT INTO accounts VALUES (0575,0575, 10000, 'USER0575', SYSDATE);
INSERT INTO accounts VALUES (0576,0576, 10000, 'USER0576', SYSDATE);
INSERT INTO accounts VALUES (0577,0577, 10000, 'USER0577', SYSDATE);
INSERT INTO accounts VALUES (0578,0578, 10000, 'USER0578', SYSDATE);
INSERT INTO accounts VALUES (0579,0579, 10000, 'USER0579', SYSDATE);
INSERT INTO accounts VALUES (0580,0580, 10000, 'USER0580', SYSDATE);
INSERT INTO accounts VALUES (0581,0581, 10000, 'USER0581', SYSDATE);
INSERT INTO accounts VALUES (0582,0582, 10000, 'USER0582', SYSDATE);
INSERT INTO accounts VALUES (0583,0583, 10000, 'USER0583', SYSDATE);
INSERT INTO accounts VALUES (0584,0584, 10000, 'USER0584', SYSDATE);
INSERT INTO accounts VALUES (0585,0585, 10000, 'USER0585', SYSDATE);
INSERT INTO accounts VALUES (0586,0586, 10000, 'USER0586', SYSDATE);
INSERT INTO accounts VALUES (0587,0587, 10000, 'USER0587', SYSDATE);
INSERT INTO accounts VALUES (0588,0588, 10000, 'USER0588', SYSDATE);
INSERT INTO accounts VALUES (0589,0589, 10000, 'USER0589', SYSDATE);
INSERT INTO accounts VALUES (0590,0590, 10000, 'USER0590', SYSDATE);
INSERT INTO accounts VALUES (0591,0591, 10000, 'USER0591', SYSDATE);
INSERT INTO accounts VALUES (0592,0592, 10000, 'USER0592', SYSDATE);
INSERT INTO accounts VALUES (0593,0593, 10000, 'USER0593', SYSDATE);
INSERT INTO accounts VALUES (0594,0594, 10000, 'USER0594', SYSDATE);
INSERT INTO accounts VALUES (0595,0595, 10000, 'USER0595', SYSDATE);
INSERT INTO accounts VALUES (0596,0596, 10000, 'USER0596', SYSDATE);
INSERT INTO accounts VALUES (0597,0597, 10000, 'USER0597', SYSDATE);
INSERT INTO accounts VALUES (0598,0598, 10000, 'USER0598', SYSDATE);
INSERT INTO accounts VALUES (0599,0599, 10000, 'USER0599', SYSDATE);
INSERT INTO accounts VALUES (0600,0600, 10000, 'USER0600', SYSDATE);
COMMIT;
INSERT INTO accounts VALUES (0601,0601, 10000, 'USER0601', SYSDATE);
INSERT INTO accounts VALUES (0602,0602, 10000, 'USER0602', SYSDATE);
INSERT INTO accounts VALUES (0603,0603, 10000, 'USER0603', SYSDATE);
INSERT INTO accounts VALUES (0604,0604, 10000, 'USER0604', SYSDATE);
INSERT INTO accounts VALUES (0605,0605, 10000, 'USER0605', SYSDATE);
INSERT INTO accounts VALUES (0606,0606, 10000, 'USER0606', SYSDATE);
INSERT INTO accounts VALUES (0607,0607, 10000, 'USER0607', SYSDATE);
INSERT INTO accounts VALUES (0608,0608, 10000, 'USER0608', SYSDATE);
INSERT INTO accounts VALUES (0609,0609, 10000, 'USER0609', SYSDATE);
INSERT INTO accounts VALUES (0610,0610, 10000, 'USER0610', SYSDATE);
INSERT INTO accounts VALUES (0611,0611, 10000, 'USER0611', SYSDATE);
INSERT INTO accounts VALUES (0612,0612, 10000, 'USER0612', SYSDATE);
INSERT INTO accounts VALUES (0613,0613, 10000, 'USER0613', SYSDATE);
INSERT INTO accounts VALUES (0614,0614, 10000, 'USER0614', SYSDATE);
INSERT INTO accounts VALUES (0615,0615, 10000, 'USER0615', SYSDATE);
INSERT INTO accounts VALUES (0616,0616, 10000, 'USER0616', SYSDATE);
INSERT INTO accounts VALUES (0617,0617, 10000, 'USER0617', SYSDATE);
INSERT INTO accounts VALUES (0618,0618, 10000, 'USER0618', SYSDATE);
INSERT INTO accounts VALUES (0619,0619, 10000, 'USER0619', SYSDATE);
INSERT INTO accounts VALUES (0620,0620, 10000, 'USER0620', SYSDATE);
INSERT INTO accounts VALUES (0621,0621, 10000, 'USER0621', SYSDATE);
INSERT INTO accounts VALUES (0622,0622, 10000, 'USER0622', SYSDATE);
INSERT INTO accounts VALUES (0623,0623, 10000, 'USER0623', SYSDATE);
INSERT INTO accounts VALUES (0624,0624, 10000, 'USER0624', SYSDATE);
INSERT INTO accounts VALUES (0625,0625, 10000, 'USER0625', SYSDATE);
INSERT INTO accounts VALUES (0626,0626, 10000, 'USER0626', SYSDATE);
INSERT INTO accounts VALUES (0627,0627, 10000, 'USER0627', SYSDATE);
INSERT INTO accounts VALUES (0628,0628, 10000, 'USER0628', SYSDATE);
INSERT INTO accounts VALUES (0629,0629, 10000, 'USER0629', SYSDATE);
INSERT INTO accounts VALUES (0630,0630, 10000, 'USER0630', SYSDATE);
INSERT INTO accounts VALUES (0631,0631, 10000, 'USER0631', SYSDATE);
INSERT INTO accounts VALUES (0632,0632, 10000, 'USER0632', SYSDATE);
INSERT INTO accounts VALUES (0633,0633, 10000, 'USER0633', SYSDATE);
INSERT INTO accounts VALUES (0634,0634, 10000, 'USER0634', SYSDATE);
INSERT INTO accounts VALUES (0635,0635, 10000, 'USER0635', SYSDATE);
INSERT INTO accounts VALUES (0636,0636, 10000, 'USER0636', SYSDATE);
INSERT INTO accounts VALUES (0637,0637, 10000, 'USER0637', SYSDATE);
INSERT INTO accounts VALUES (0638,0638, 10000, 'USER0638', SYSDATE);
INSERT INTO accounts VALUES (0639,0639, 10000, 'USER0639', SYSDATE);
INSERT INTO accounts VALUES (0640,0640, 10000, 'USER0640', SYSDATE);
INSERT INTO accounts VALUES (0641,0641, 10000, 'USER0641', SYSDATE);
INSERT INTO accounts VALUES (0642,0642, 10000, 'USER0642', SYSDATE);
INSERT INTO accounts VALUES (0643,0643, 10000, 'USER0643', SYSDATE);
INSERT INTO accounts VALUES (0644,0644, 10000, 'USER0644', SYSDATE);
INSERT INTO accounts VALUES (0645,0645, 10000, 'USER0645', SYSDATE);
INSERT INTO accounts VALUES (0646,0646, 10000, 'USER0646', SYSDATE);
INSERT INTO accounts VALUES (0647,0647, 10000, 'USER0647', SYSDATE);
INSERT INTO accounts VALUES (0648,0648, 10000, 'USER0648', SYSDATE);
INSERT INTO accounts VALUES (0649,0649, 10000, 'USER0649', SYSDATE);
INSERT INTO accounts VALUES (0650,0650, 10000, 'USER0650', SYSDATE);
INSERT INTO accounts VALUES (0651,0651, 10000, 'USER0651', SYSDATE);
INSERT INTO accounts VALUES (0652,0652, 10000, 'USER0652', SYSDATE);
INSERT INTO accounts VALUES (0653,0653, 10000, 'USER0653', SYSDATE);
INSERT INTO accounts VALUES (0654,0654, 10000, 'USER0654', SYSDATE);
INSERT INTO accounts VALUES (0655,0655, 10000, 'USER0655', SYSDATE);
INSERT INTO accounts VALUES (0656,0656, 10000, 'USER0656', SYSDATE);
INSERT INTO accounts VALUES (0657,0657, 10000, 'USER0657', SYSDATE);
INSERT INTO accounts VALUES (0658,0658, 10000, 'USER0658', SYSDATE);
INSERT INTO accounts VALUES (0659,0659, 10000, 'USER0659', SYSDATE);
INSERT INTO accounts VALUES (0660,0660, 10000, 'USER0660', SYSDATE);
INSERT INTO accounts VALUES (0661,0661, 10000, 'USER0661', SYSDATE);
INSERT INTO accounts VALUES (0662,0662, 10000, 'USER0662', SYSDATE);
INSERT INTO accounts VALUES (0663,0663, 10000, 'USER0663', SYSDATE);
INSERT INTO accounts VALUES (0664,0664, 10000, 'USER0664', SYSDATE);
INSERT INTO accounts VALUES (0665,0665, 10000, 'USER0665', SYSDATE);
INSERT INTO accounts VALUES (0666,0666, 10000, 'USER0666', SYSDATE);
INSERT INTO accounts VALUES (0667,0667, 10000, 'USER0667', SYSDATE);
INSERT INTO accounts VALUES (0668,0668, 10000, 'USER0668', SYSDATE);
INSERT INTO accounts VALUES (0669,0669, 10000, 'USER0669', SYSDATE);
INSERT INTO accounts VALUES (0670,0670, 10000, 'USER0670', SYSDATE);
INSERT INTO accounts VALUES (0671,0671, 10000, 'USER0671', SYSDATE);
INSERT INTO accounts VALUES (0672,0672, 10000, 'USER0672', SYSDATE);
INSERT INTO accounts VALUES (0673,0673, 10000, 'USER0673', SYSDATE);
INSERT INTO accounts VALUES (0674,0674, 10000, 'USER0674', SYSDATE);
INSERT INTO accounts VALUES (0675,0675, 10000, 'USER0675', SYSDATE);
INSERT INTO accounts VALUES (0676,0676, 10000, 'USER0676', SYSDATE);
INSERT INTO accounts VALUES (0677,0677, 10000, 'USER0677', SYSDATE);
INSERT INTO accounts VALUES (0678,0678, 10000, 'USER0678', SYSDATE);
INSERT INTO accounts VALUES (0679,0679, 10000, 'USER0679', SYSDATE);
INSERT INTO accounts VALUES (0680,0680, 10000, 'USER0680', SYSDATE);
INSERT INTO accounts VALUES (0681,0681, 10000, 'USER0681', SYSDATE);
INSERT INTO accounts VALUES (0682,0682, 10000, 'USER0682', SYSDATE);
INSERT INTO accounts VALUES (0683,0683, 10000, 'USER0683', SYSDATE);
INSERT INTO accounts VALUES (0684,0684, 10000, 'USER0684', SYSDATE);
INSERT INTO accounts VALUES (0685,0685, 10000, 'USER0685', SYSDATE);
INSERT INTO accounts VALUES (0686,0686, 10000, 'USER0686', SYSDATE);
INSERT INTO accounts VALUES (0687,0687, 10000, 'USER0687', SYSDATE);
INSERT INTO accounts VALUES (0688,0688, 10000, 'USER0688', SYSDATE);
INSERT INTO accounts VALUES (0689,0689, 10000, 'USER0689', SYSDATE);
INSERT INTO accounts VALUES (0690,0690, 10000, 'USER0690', SYSDATE);
INSERT INTO accounts VALUES (0691,0691, 10000, 'USER0691', SYSDATE);
INSERT INTO accounts VALUES (0692,0692, 10000, 'USER0692', SYSDATE);
INSERT INTO accounts VALUES (0693,0693, 10000, 'USER0693', SYSDATE);
INSERT INTO accounts VALUES (0694,0694, 10000, 'USER0694', SYSDATE);
INSERT INTO accounts VALUES (0695,0695, 10000, 'USER0695', SYSDATE);
INSERT INTO accounts VALUES (0696,0696, 10000, 'USER0696', SYSDATE);
INSERT INTO accounts VALUES (0697,0697, 10000, 'USER0697', SYSDATE);
INSERT INTO accounts VALUES (0698,0698, 10000, 'USER0698', SYSDATE);
INSERT INTO accounts VALUES (0699,0699, 10000, 'USER0699', SYSDATE);
INSERT INTO accounts VALUES (0700,0700, 10000, 'USER0700', SYSDATE);
COMMIT;
INSERT INTO accounts VALUES (0701,0701, 10000, 'USER0701', SYSDATE);
INSERT INTO accounts VALUES (0702,0702, 10000, 'USER0702', SYSDATE);
INSERT INTO accounts VALUES (0703,0703, 10000, 'USER0703', SYSDATE);
INSERT INTO accounts VALUES (0704,0704, 10000, 'USER0704', SYSDATE);
INSERT INTO accounts VALUES (0705,0705, 10000, 'USER0705', SYSDATE);
INSERT INTO accounts VALUES (0706,0706, 10000, 'USER0706', SYSDATE);
INSERT INTO accounts VALUES (0707,0707, 10000, 'USER0707', SYSDATE);
INSERT INTO accounts VALUES (0708,0708, 10000, 'USER0708', SYSDATE);
INSERT INTO accounts VALUES (0709,0709, 10000, 'USER0709', SYSDATE);
INSERT INTO accounts VALUES (0710,0710, 10000, 'USER0710', SYSDATE);
INSERT INTO accounts VALUES (0711,0711, 10000, 'USER0711', SYSDATE);
INSERT INTO accounts VALUES (0712,0712, 10000, 'USER0712', SYSDATE);
INSERT INTO accounts VALUES (0713,0713, 10000, 'USER0713', SYSDATE);
INSERT INTO accounts VALUES (0714,0714, 10000, 'USER0714', SYSDATE);
INSERT INTO accounts VALUES (0715,0715, 10000, 'USER0715', SYSDATE);
INSERT INTO accounts VALUES (0716,0716, 10000, 'USER0716', SYSDATE);
INSERT INTO accounts VALUES (0717,0717, 10000, 'USER0717', SYSDATE);
INSERT INTO accounts VALUES (0718,0718, 10000, 'USER0718', SYSDATE);
INSERT INTO accounts VALUES (0719,0719, 10000, 'USER0719', SYSDATE);
INSERT INTO accounts VALUES (0720,0720, 10000, 'USER0720', SYSDATE);
INSERT INTO accounts VALUES (0721,0721, 10000, 'USER0721', SYSDATE);
INSERT INTO accounts VALUES (0722,0722, 10000, 'USER0722', SYSDATE);
INSERT INTO accounts VALUES (0723,0723, 10000, 'USER0723', SYSDATE);
INSERT INTO accounts VALUES (0724,0724, 10000, 'USER0724', SYSDATE);
INSERT INTO accounts VALUES (0725,0725, 10000, 'USER0725', SYSDATE);
INSERT INTO accounts VALUES (0726,0726, 10000, 'USER0726', SYSDATE);
INSERT INTO accounts VALUES (0727,0727, 10000, 'USER0727', SYSDATE);
INSERT INTO accounts VALUES (0728,0728, 10000, 'USER0728', SYSDATE);
INSERT INTO accounts VALUES (0729,0729, 10000, 'USER0729', SYSDATE);
INSERT INTO accounts VALUES (0730,0730, 10000, 'USER0730', SYSDATE);
INSERT INTO accounts VALUES (0731,0731, 10000, 'USER0731', SYSDATE);
INSERT INTO accounts VALUES (0732,0732, 10000, 'USER0732', SYSDATE);
INSERT INTO accounts VALUES (0733,0733, 10000, 'USER0733', SYSDATE);
INSERT INTO accounts VALUES (0734,0734, 10000, 'USER0734', SYSDATE);
INSERT INTO accounts VALUES (0735,0735, 10000, 'USER0735', SYSDATE);
INSERT INTO accounts VALUES (0736,0736, 10000, 'USER0736', SYSDATE);
INSERT INTO accounts VALUES (0737,0737, 10000, 'USER0737', SYSDATE);
INSERT INTO accounts VALUES (0738,0738, 10000, 'USER0738', SYSDATE);
INSERT INTO accounts VALUES (0739,0739, 10000, 'USER0739', SYSDATE);
INSERT INTO accounts VALUES (0740,0740, 10000, 'USER0740', SYSDATE);
INSERT INTO accounts VALUES (0741,0741, 10000, 'USER0741', SYSDATE);
INSERT INTO accounts VALUES (0742,0742, 10000, 'USER0742', SYSDATE);
INSERT INTO accounts VALUES (0743,0743, 10000, 'USER0743', SYSDATE);
INSERT INTO accounts VALUES (0744,0744, 10000, 'USER0744', SYSDATE);
INSERT INTO accounts VALUES (0745,0745, 10000, 'USER0745', SYSDATE);
INSERT INTO accounts VALUES (0746,0746, 10000, 'USER0746', SYSDATE);
INSERT INTO accounts VALUES (0747,0747, 10000, 'USER0747', SYSDATE);
INSERT INTO accounts VALUES (0748,0748, 10000, 'USER0748', SYSDATE);
INSERT INTO accounts VALUES (0749,0749, 10000, 'USER0749', SYSDATE);
INSERT INTO accounts VALUES (0750,0750, 10000, 'USER0750', SYSDATE);
INSERT INTO accounts VALUES (0751,0751, 10000, 'USER0751', SYSDATE);
INSERT INTO accounts VALUES (0752,0752, 10000, 'USER0752', SYSDATE);
INSERT INTO accounts VALUES (0753,0753, 10000, 'USER0753', SYSDATE);
INSERT INTO accounts VALUES (0754,0754, 10000, 'USER0754', SYSDATE);
INSERT INTO accounts VALUES (0755,0755, 10000, 'USER0755', SYSDATE);
INSERT INTO accounts VALUES (0756,0756, 10000, 'USER0756', SYSDATE);
INSERT INTO accounts VALUES (0757,0757, 10000, 'USER0757', SYSDATE);
INSERT INTO accounts VALUES (0758,0758, 10000, 'USER0758', SYSDATE);
INSERT INTO accounts VALUES (0759,0759, 10000, 'USER0759', SYSDATE);
INSERT INTO accounts VALUES (0760,0760, 10000, 'USER0760', SYSDATE);
INSERT INTO accounts VALUES (0761,0761, 10000, 'USER0761', SYSDATE);
INSERT INTO accounts VALUES (0762,0762, 10000, 'USER0762', SYSDATE);
INSERT INTO accounts VALUES (0763,0763, 10000, 'USER0763', SYSDATE);
INSERT INTO accounts VALUES (0764,0764, 10000, 'USER0764', SYSDATE);
INSERT INTO accounts VALUES (0765,0765, 10000, 'USER0765', SYSDATE);
INSERT INTO accounts VALUES (0766,0766, 10000, 'USER0766', SYSDATE);
INSERT INTO accounts VALUES (0767,0767, 10000, 'USER0767', SYSDATE);
INSERT INTO accounts VALUES (0768,0768, 10000, 'USER0768', SYSDATE);
INSERT INTO accounts VALUES (0769,0769, 10000, 'USER0769', SYSDATE);
INSERT INTO accounts VALUES (0770,0770, 10000, 'USER0770', SYSDATE);
INSERT INTO accounts VALUES (0771,0771, 10000, 'USER0771', SYSDATE);
INSERT INTO accounts VALUES (0772,0772, 10000, 'USER0772', SYSDATE);
INSERT INTO accounts VALUES (0773,0773, 10000, 'USER0773', SYSDATE);
INSERT INTO accounts VALUES (0774,0774, 10000, 'USER0774', SYSDATE);
INSERT INTO accounts VALUES (0775,0775, 10000, 'USER0775', SYSDATE);
INSERT INTO accounts VALUES (0776,0776, 10000, 'USER0776', SYSDATE);
INSERT INTO accounts VALUES (0777,0777, 10000, 'USER0777', SYSDATE);
INSERT INTO accounts VALUES (0778,0778, 10000, 'USER0778', SYSDATE);
INSERT INTO accounts VALUES (0779,0779, 10000, 'USER0779', SYSDATE);
INSERT INTO accounts VALUES (0780,0780, 10000, 'USER0780', SYSDATE);
INSERT INTO accounts VALUES (0781,0781, 10000, 'USER0781', SYSDATE);
INSERT INTO accounts VALUES (0782,0782, 10000, 'USER0782', SYSDATE);
INSERT INTO accounts VALUES (0783,0783, 10000, 'USER0783', SYSDATE);
INSERT INTO accounts VALUES (0784,0784, 10000, 'USER0784', SYSDATE);
INSERT INTO accounts VALUES (0785,0785, 10000, 'USER0785', SYSDATE);
INSERT INTO accounts VALUES (0786,0786, 10000, 'USER0786', SYSDATE);
INSERT INTO accounts VALUES (0787,0787, 10000, 'USER0787', SYSDATE);
INSERT INTO accounts VALUES (0788,0788, 10000, 'USER0788', SYSDATE);
INSERT INTO accounts VALUES (0789,0789, 10000, 'USER0789', SYSDATE);
INSERT INTO accounts VALUES (0790,0790, 10000, 'USER0790', SYSDATE);
INSERT INTO accounts VALUES (0791,0791, 10000, 'USER0791', SYSDATE);
INSERT INTO accounts VALUES (0792,0792, 10000, 'USER0792', SYSDATE);
INSERT INTO accounts VALUES (0793,0793, 10000, 'USER0793', SYSDATE);
INSERT INTO accounts VALUES (0794,0794, 10000, 'USER0794', SYSDATE);
INSERT INTO accounts VALUES (0795,0795, 10000, 'USER0795', SYSDATE);
INSERT INTO accounts VALUES (0796,0796, 10000, 'USER0796', SYSDATE);
INSERT INTO accounts VALUES (0797,0797, 10000, 'USER0797', SYSDATE);
INSERT INTO accounts VALUES (0798,0798, 10000, 'USER0798', SYSDATE);
INSERT INTO accounts VALUES (0799,0799, 10000, 'USER0799', SYSDATE);
INSERT INTO accounts VALUES (0800,0800, 10000, 'USER0800', SYSDATE);
COMMIT;
INSERT INTO accounts VALUES (0801,0801, 10000, 'USER0801', SYSDATE);
INSERT INTO accounts VALUES (0802,0802, 10000, 'USER0802', SYSDATE);
INSERT INTO accounts VALUES (0803,0803, 10000, 'USER0803', SYSDATE);
INSERT INTO accounts VALUES (0804,0804, 10000, 'USER0804', SYSDATE);
INSERT INTO accounts VALUES (0805,0805, 10000, 'USER0805', SYSDATE);
INSERT INTO accounts VALUES (0806,0806, 10000, 'USER0806', SYSDATE);
INSERT INTO accounts VALUES (0807,0807, 10000, 'USER0807', SYSDATE);
INSERT INTO accounts VALUES (0808,0808, 10000, 'USER0808', SYSDATE);
INSERT INTO accounts VALUES (0809,0809, 10000, 'USER0809', SYSDATE);
INSERT INTO accounts VALUES (0810,0810, 10000, 'USER0810', SYSDATE);
INSERT INTO accounts VALUES (0811,0811, 10000, 'USER0811', SYSDATE);
INSERT INTO accounts VALUES (0812,0812, 10000, 'USER0812', SYSDATE);
INSERT INTO accounts VALUES (0813,0813, 10000, 'USER0813', SYSDATE);
INSERT INTO accounts VALUES (0814,0814, 10000, 'USER0814', SYSDATE);
INSERT INTO accounts VALUES (0815,0815, 10000, 'USER0815', SYSDATE);
INSERT INTO accounts VALUES (0816,0816, 10000, 'USER0816', SYSDATE);
INSERT INTO accounts VALUES (0817,0817, 10000, 'USER0817', SYSDATE);
INSERT INTO accounts VALUES (0818,0818, 10000, 'USER0818', SYSDATE);
INSERT INTO accounts VALUES (0819,0819, 10000, 'USER0819', SYSDATE);
INSERT INTO accounts VALUES (0820,0820, 10000, 'USER0820', SYSDATE);
INSERT INTO accounts VALUES (0821,0821, 10000, 'USER0821', SYSDATE);
INSERT INTO accounts VALUES (0822,0822, 10000, 'USER0822', SYSDATE);
INSERT INTO accounts VALUES (0823,0823, 10000, 'USER0823', SYSDATE);
INSERT INTO accounts VALUES (0824,0824, 10000, 'USER0824', SYSDATE);
INSERT INTO accounts VALUES (0825,0825, 10000, 'USER0825', SYSDATE);
INSERT INTO accounts VALUES (0826,0826, 10000, 'USER0826', SYSDATE);
INSERT INTO accounts VALUES (0827,0827, 10000, 'USER0827', SYSDATE);
INSERT INTO accounts VALUES (0828,0828, 10000, 'USER0828', SYSDATE);
INSERT INTO accounts VALUES (0829,0829, 10000, 'USER0829', SYSDATE);
INSERT INTO accounts VALUES (0830,0830, 10000, 'USER0830', SYSDATE);
INSERT INTO accounts VALUES (0831,0831, 10000, 'USER0831', SYSDATE);
INSERT INTO accounts VALUES (0832,0832, 10000, 'USER0832', SYSDATE);
INSERT INTO accounts VALUES (0833,0833, 10000, 'USER0833', SYSDATE);
INSERT INTO accounts VALUES (0834,0834, 10000, 'USER0834', SYSDATE);
INSERT INTO accounts VALUES (0835,0835, 10000, 'USER0835', SYSDATE);
INSERT INTO accounts VALUES (0836,0836, 10000, 'USER0836', SYSDATE);
INSERT INTO accounts VALUES (0837,0837, 10000, 'USER0837', SYSDATE);
INSERT INTO accounts VALUES (0838,0838, 10000, 'USER0838', SYSDATE);
INSERT INTO accounts VALUES (0839,0839, 10000, 'USER0839', SYSDATE);
INSERT INTO accounts VALUES (0840,0840, 10000, 'USER0840', SYSDATE);
INSERT INTO accounts VALUES (0841,0841, 10000, 'USER0841', SYSDATE);
INSERT INTO accounts VALUES (0842,0842, 10000, 'USER0842', SYSDATE);
INSERT INTO accounts VALUES (0843,0843, 10000, 'USER0843', SYSDATE);
INSERT INTO accounts VALUES (0844,0844, 10000, 'USER0844', SYSDATE);
INSERT INTO accounts VALUES (0845,0845, 10000, 'USER0845', SYSDATE);
INSERT INTO accounts VALUES (0846,0846, 10000, 'USER0846', SYSDATE);
INSERT INTO accounts VALUES (0847,0847, 10000, 'USER0847', SYSDATE);
INSERT INTO accounts VALUES (0848,0848, 10000, 'USER0848', SYSDATE);
INSERT INTO accounts VALUES (0849,0849, 10000, 'USER0849', SYSDATE);
INSERT INTO accounts VALUES (0850,0850, 10000, 'USER0850', SYSDATE);
INSERT INTO accounts VALUES (0851,0851, 10000, 'USER0851', SYSDATE);
INSERT INTO accounts VALUES (0852,0852, 10000, 'USER0852', SYSDATE);
INSERT INTO accounts VALUES (0853,0853, 10000, 'USER0853', SYSDATE);
INSERT INTO accounts VALUES (0854,0854, 10000, 'USER0854', SYSDATE);
INSERT INTO accounts VALUES (0855,0855, 10000, 'USER0855', SYSDATE);
INSERT INTO accounts VALUES (0856,0856, 10000, 'USER0856', SYSDATE);
INSERT INTO accounts VALUES (0857,0857, 10000, 'USER0857', SYSDATE);
INSERT INTO accounts VALUES (0858,0858, 10000, 'USER0858', SYSDATE);
INSERT INTO accounts VALUES (0859,0859, 10000, 'USER0859', SYSDATE);
INSERT INTO accounts VALUES (0860,0860, 10000, 'USER0860', SYSDATE);
INSERT INTO accounts VALUES (0861,0861, 10000, 'USER0861', SYSDATE);
INSERT INTO accounts VALUES (0862,0862, 10000, 'USER0862', SYSDATE);
INSERT INTO accounts VALUES (0863,0863, 10000, 'USER0863', SYSDATE);
INSERT INTO accounts VALUES (0864,0864, 10000, 'USER0864', SYSDATE);
INSERT INTO accounts VALUES (0865,0865, 10000, 'USER0865', SYSDATE);
INSERT INTO accounts VALUES (0866,0866, 10000, 'USER0866', SYSDATE);
INSERT INTO accounts VALUES (0867,0867, 10000, 'USER0867', SYSDATE);
INSERT INTO accounts VALUES (0868,0868, 10000, 'USER0868', SYSDATE);
INSERT INTO accounts VALUES (0869,0869, 10000, 'USER0869', SYSDATE);
INSERT INTO accounts VALUES (0870,0870, 10000, 'USER0870', SYSDATE);
INSERT INTO accounts VALUES (0871,0871, 10000, 'USER0871', SYSDATE);
INSERT INTO accounts VALUES (0872,0872, 10000, 'USER0872', SYSDATE);
INSERT INTO accounts VALUES (0873,0873, 10000, 'USER0873', SYSDATE);
INSERT INTO accounts VALUES (0874,0874, 10000, 'USER0874', SYSDATE);
INSERT INTO accounts VALUES (0875,0875, 10000, 'USER0875', SYSDATE);
INSERT INTO accounts VALUES (0876,0876, 10000, 'USER0876', SYSDATE);
INSERT INTO accounts VALUES (0877,0877, 10000, 'USER0877', SYSDATE);
INSERT INTO accounts VALUES (0878,0878, 10000, 'USER0878', SYSDATE);
INSERT INTO accounts VALUES (0879,0879, 10000, 'USER0879', SYSDATE);
INSERT INTO accounts VALUES (0880,0880, 10000, 'USER0880', SYSDATE);
INSERT INTO accounts VALUES (0881,0881, 10000, 'USER0881', SYSDATE);
INSERT INTO accounts VALUES (0882,0882, 10000, 'USER0882', SYSDATE);
INSERT INTO accounts VALUES (0883,0883, 10000, 'USER0883', SYSDATE);
INSERT INTO accounts VALUES (0884,0884, 10000, 'USER0884', SYSDATE);
INSERT INTO accounts VALUES (0885,0885, 10000, 'USER0885', SYSDATE);
INSERT INTO accounts VALUES (0886,0886, 10000, 'USER0886', SYSDATE);
INSERT INTO accounts VALUES (0887,0887, 10000, 'USER0887', SYSDATE);
INSERT INTO accounts VALUES (0888,0888, 10000, 'USER0888', SYSDATE);
INSERT INTO accounts VALUES (0889,0889, 10000, 'USER0889', SYSDATE);
INSERT INTO accounts VALUES (0890,0890, 10000, 'USER0890', SYSDATE);
INSERT INTO accounts VALUES (0891,0891, 10000, 'USER0891', SYSDATE);
INSERT INTO accounts VALUES (0892,0892, 10000, 'USER0892', SYSDATE);
INSERT INTO accounts VALUES (0893,0893, 10000, 'USER0893', SYSDATE);
INSERT INTO accounts VALUES (0894,0894, 10000, 'USER0894', SYSDATE);
INSERT INTO accounts VALUES (0895,0895, 10000, 'USER0895', SYSDATE);
INSERT INTO accounts VALUES (0896,0896, 10000, 'USER0896', SYSDATE);
INSERT INTO accounts VALUES (0897,0897, 10000, 'USER0897', SYSDATE);
INSERT INTO accounts VALUES (0898,0898, 10000, 'USER0898', SYSDATE);
INSERT INTO accounts VALUES (0899,0899, 10000, 'USER0899', SYSDATE);
INSERT INTO accounts VALUES (0900,0900, 10000, 'USER0900', SYSDATE);
COMMIT;
INSERT INTO accounts VALUES (0901,0901, 10000, 'USER0901', SYSDATE);
INSERT INTO accounts VALUES (0902,0902, 10000, 'USER0902', SYSDATE);
INSERT INTO accounts VALUES (0903,0903, 10000, 'USER0903', SYSDATE);
INSERT INTO accounts VALUES (0904,0904, 10000, 'USER0904', SYSDATE);
INSERT INTO accounts VALUES (0905,0905, 10000, 'USER0905', SYSDATE);
INSERT INTO accounts VALUES (0906,0906, 10000, 'USER0906', SYSDATE);
INSERT INTO accounts VALUES (0907,0907, 10000, 'USER0907', SYSDATE);
INSERT INTO accounts VALUES (0908,0908, 10000, 'USER0908', SYSDATE);
INSERT INTO accounts VALUES (0909,0909, 10000, 'USER0909', SYSDATE);
INSERT INTO accounts VALUES (0910,0910, 10000, 'USER0910', SYSDATE);
INSERT INTO accounts VALUES (0911,0911, 10000, 'USER0911', SYSDATE);
INSERT INTO accounts VALUES (0912,0912, 10000, 'USER0912', SYSDATE);
INSERT INTO accounts VALUES (0913,0913, 10000, 'USER0913', SYSDATE);
INSERT INTO accounts VALUES (0914,0914, 10000, 'USER0914', SYSDATE);
INSERT INTO accounts VALUES (0915,0915, 10000, 'USER0915', SYSDATE);
INSERT INTO accounts VALUES (0916,0916, 10000, 'USER0916', SYSDATE);
INSERT INTO accounts VALUES (0917,0917, 10000, 'USER0917', SYSDATE);
INSERT INTO accounts VALUES (0918,0918, 10000, 'USER0918', SYSDATE);
INSERT INTO accounts VALUES (0919,0919, 10000, 'USER0919', SYSDATE);
INSERT INTO accounts VALUES (0920,0920, 10000, 'USER0920', SYSDATE);
INSERT INTO accounts VALUES (0921,0921, 10000, 'USER0921', SYSDATE);
INSERT INTO accounts VALUES (0922,0922, 10000, 'USER0922', SYSDATE);
INSERT INTO accounts VALUES (0923,0923, 10000, 'USER0923', SYSDATE);
INSERT INTO accounts VALUES (0924,0924, 10000, 'USER0924', SYSDATE);
INSERT INTO accounts VALUES (0925,0925, 10000, 'USER0925', SYSDATE);
INSERT INTO accounts VALUES (0926,0926, 10000, 'USER0926', SYSDATE);
INSERT INTO accounts VALUES (0927,0927, 10000, 'USER0927', SYSDATE);
INSERT INTO accounts VALUES (0928,0928, 10000, 'USER0928', SYSDATE);
INSERT INTO accounts VALUES (0929,0929, 10000, 'USER0929', SYSDATE);
INSERT INTO accounts VALUES (0930,0930, 10000, 'USER0930', SYSDATE);
INSERT INTO accounts VALUES (0931,0931, 10000, 'USER0931', SYSDATE);
INSERT INTO accounts VALUES (0932,0932, 10000, 'USER0932', SYSDATE);
INSERT INTO accounts VALUES (0933,0933, 10000, 'USER0933', SYSDATE);
INSERT INTO accounts VALUES (0934,0934, 10000, 'USER0934', SYSDATE);
INSERT INTO accounts VALUES (0935,0935, 10000, 'USER0935', SYSDATE);
INSERT INTO accounts VALUES (0936,0936, 10000, 'USER0936', SYSDATE);
INSERT INTO accounts VALUES (0937,0937, 10000, 'USER0937', SYSDATE);
INSERT INTO accounts VALUES (0938,0938, 10000, 'USER0938', SYSDATE);
INSERT INTO accounts VALUES (0939,0939, 10000, 'USER0939', SYSDATE);
INSERT INTO accounts VALUES (0940,0940, 10000, 'USER0940', SYSDATE);
INSERT INTO accounts VALUES (0941,0941, 10000, 'USER0941', SYSDATE);
INSERT INTO accounts VALUES (0942,0942, 10000, 'USER0942', SYSDATE);
INSERT INTO accounts VALUES (0943,0943, 10000, 'USER0943', SYSDATE);
INSERT INTO accounts VALUES (0944,0944, 10000, 'USER0944', SYSDATE);
INSERT INTO accounts VALUES (0945,0945, 10000, 'USER0945', SYSDATE);
INSERT INTO accounts VALUES (0946,0946, 10000, 'USER0946', SYSDATE);
INSERT INTO accounts VALUES (0947,0947, 10000, 'USER0947', SYSDATE);
INSERT INTO accounts VALUES (0948,0948, 10000, 'USER0948', SYSDATE);
INSERT INTO accounts VALUES (0949,0949, 10000, 'USER0949', SYSDATE);
INSERT INTO accounts VALUES (0950,0950, 10000, 'USER0950', SYSDATE);
INSERT INTO accounts VALUES (0951,0951, 10000, 'USER0951', SYSDATE);
INSERT INTO accounts VALUES (0952,0952, 10000, 'USER0952', SYSDATE);
INSERT INTO accounts VALUES (0953,0953, 10000, 'USER0953', SYSDATE);
INSERT INTO accounts VALUES (0954,0954, 10000, 'USER0954', SYSDATE);
INSERT INTO accounts VALUES (0955,0955, 10000, 'USER0955', SYSDATE);
INSERT INTO accounts VALUES (0956,0956, 10000, 'USER0956', SYSDATE);
INSERT INTO accounts VALUES (0957,0957, 10000, 'USER0957', SYSDATE);
INSERT INTO accounts VALUES (0958,0958, 10000, 'USER0958', SYSDATE);
INSERT INTO accounts VALUES (0959,0959, 10000, 'USER0959', SYSDATE);
INSERT INTO accounts VALUES (0960,0960, 10000, 'USER0960', SYSDATE);
INSERT INTO accounts VALUES (0961,0961, 10000, 'USER0961', SYSDATE);
INSERT INTO accounts VALUES (0962,0962, 10000, 'USER0962', SYSDATE);
INSERT INTO accounts VALUES (0963,0963, 10000, 'USER0963', SYSDATE);
INSERT INTO accounts VALUES (0964,0964, 10000, 'USER0964', SYSDATE);
INSERT INTO accounts VALUES (0965,0965, 10000, 'USER0965', SYSDATE);
INSERT INTO accounts VALUES (0966,0966, 10000, 'USER0966', SYSDATE);
INSERT INTO accounts VALUES (0967,0967, 10000, 'USER0967', SYSDATE);
INSERT INTO accounts VALUES (0968,0968, 10000, 'USER0968', SYSDATE);
INSERT INTO accounts VALUES (0969,0969, 10000, 'USER0969', SYSDATE);
INSERT INTO accounts VALUES (0970,0970, 10000, 'USER0970', SYSDATE);
INSERT INTO accounts VALUES (0971,0971, 10000, 'USER0971', SYSDATE);
INSERT INTO accounts VALUES (0972,0972, 10000, 'USER0972', SYSDATE);
INSERT INTO accounts VALUES (0973,0973, 10000, 'USER0973', SYSDATE);
INSERT INTO accounts VALUES (0974,0974, 10000, 'USER0974', SYSDATE);
INSERT INTO accounts VALUES (0975,0975, 10000, 'USER0975', SYSDATE);
INSERT INTO accounts VALUES (0976,0976, 10000, 'USER0976', SYSDATE);
INSERT INTO accounts VALUES (0977,0977, 10000, 'USER0977', SYSDATE);
INSERT INTO accounts VALUES (0978,0978, 10000, 'USER0978', SYSDATE);
INSERT INTO accounts VALUES (0979,0979, 10000, 'USER0979', SYSDATE);
INSERT INTO accounts VALUES (0980,0980, 10000, 'USER0980', SYSDATE);
INSERT INTO accounts VALUES (0981,0981, 10000, 'USER0981', SYSDATE);
INSERT INTO accounts VALUES (0982,0982, 10000, 'USER0982', SYSDATE);
INSERT INTO accounts VALUES (0983,0983, 10000, 'USER0983', SYSDATE);
INSERT INTO accounts VALUES (0984,0984, 10000, 'USER0984', SYSDATE);
INSERT INTO accounts VALUES (0985,0985, 10000, 'USER0985', SYSDATE);
INSERT INTO accounts VALUES (0986,0986, 10000, 'USER0986', SYSDATE);
INSERT INTO accounts VALUES (0987,0987, 10000, 'USER0987', SYSDATE);
INSERT INTO accounts VALUES (0988,0988, 10000, 'USER0988', SYSDATE);
INSERT INTO accounts VALUES (0989,0989, 10000, 'USER0989', SYSDATE);
INSERT INTO accounts VALUES (0990,0990, 10000, 'USER0990', SYSDATE);
INSERT INTO accounts VALUES (0991,0991, 10000, 'USER0991', SYSDATE);
INSERT INTO accounts VALUES (0992,0992, 10000, 'USER0992', SYSDATE);
INSERT INTO accounts VALUES (0993,0993, 10000, 'USER0993', SYSDATE);
INSERT INTO accounts VALUES (0994,0994, 10000, 'USER0994', SYSDATE);
INSERT INTO accounts VALUES (0995,0995, 10000, 'USER0995', SYSDATE);
INSERT INTO accounts VALUES (0996,0996, 10000, 'USER0996', SYSDATE);
INSERT INTO accounts VALUES (0997,0997, 10000, 'USER0997', SYSDATE);
INSERT INTO accounts VALUES (0998,0998, 10000, 'USER0998', SYSDATE);
INSERT INTO accounts VALUES (0999,0999, 10000, 'USER0999', SYSDATE);
COMMIT;

create or replace procedure validate_atm_txns
as
  CURSOR txn_log_cursor  IS
	SELECT  
		TXNTYPE_TXACTS, TXNACCT_TXACTS, TXNAMNT_TXACTS
	FROM txacts;
   unknown_txn_type 	EXCEPTION;
   txntype              VARCHAR2(10);
   txnacct              NUMBER;
   txnamnt              NUMBER;
begin
-- for each transaction recorded in the txn log, reconcile the
-- corresponding account
     open txn_log_cursor;
     loop
	FETCH txn_log_cursor INTO txntype, txnacct, txnamnt;
        EXIT WHEN  txn_log_cursor%NOTFOUND;
        if txntype = 'CREDIT' 
        then
           txnamnt := -txnamnt;
        elsif txntype = 'DEBIT' 
        then
           txnamnt := txnamnt;
        else
           raise unknown_txn_type;
        end if;
        UPDATE accounts SET currbal_accounts =  currbal_accounts + txnamnt;
        if txn_log_cursor%ISOPEN 
        then
          close txn_log_cursor;
        end if;
      end loop;
exception
        when unknown_txn_type then raise;
end;
/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de