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; /