text: /* Automatisiertes Einfügen von Daten in das Demo Datenmodells
  zur Schulung "SQL Script 4 BW Consultants" */
  -- Harald Schütt, 27.04.2020
  --
  -- Daten für Tabelle banks
  insert into banks VALUES ('DXIADEBBXXX', 'Helaba Berlin', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('DLGHDEB1XXX', 'Eurocity Bank', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('DGZFDEFFBER', 'DekaBank', 60040, 'Frankfurt am Main');
  insert into banks VALUES ('MACODEB1XXX', 'Westend Bank', 60599, 'Frankfurt am Main');
  insert into banks VALUES ('BIWBDE33XXX', 'flatex Bank Frankfurt', 60327, 'Frankfurt am Main');
  insert into banks VALUES ('ESSEDEFFHAM', 'SEB Hamburg', 60313, 'Frankfurt am Main');
  insert into banks VALUES ('BIWBDE33303', 'flatex Bank Frankfurt', 60327, 'Frankfurt am Main');
  insert into banks VALUES ('GABKDE3EXXX', 'NIBC Bank Deutschland', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('BNPADEFFXXX', 'BNP Paribas Ndl Deutschland', 60327, 'Frankfurt am Main');
  insert into banks VALUES ('MARKDEF1500', 'BBk Filiale Frankfurt Main', 60047, 'Frankfurt am Main');
  insert into banks VALUES ('PBNKDEFFXXX', 'Postbank Ndl DB PFK', 60288, 'Frankfurt am Main');
  insert into banks VALUES ('ESSEDE5FXXX', 'DSK Hyp', 60313, 'Frankfurt am Main');
  insert into banks VALUES ('AKBKDEFFXXX', 'AKBANK', 60310, 'Frankfurt am Main');
  insert into banks VALUES ('AARBDE5W500', 'Aareal Bank', 60284, 'Frankfurt am Main');
  insert into banks VALUES ('INGDDEFFXXX', 'ING-DiBa Frankfurt am Main', 60628, 'Frankfurt am Main');
  insert into banks VALUES ('DEGUDEFFXXX', 'Degussa Bank Frankfurt Main', 60605, 'Frankfurt am Main');
  insert into banks VALUES ('BOFADEFXXXX', 'Bankamerica', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('BOFADEFXVAM', 'Bank of America', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('WUIDDEF1XXX', 'WUIB - Branch Germany', 60486, 'Frankfurt am Main');
  insert into banks VALUES ('SEZDDEF1XXX', 'Sberbank Direct Frankfurt', 60594, 'Frankfurt am Main');
  insert into banks VALUES ('BHFBDEFF500', 'ODDO BHF Frankfurt Main', 60323, 'Frankfurt am Main');
  insert into banks VALUES ('KFWIDEFFXXX', 'KfW Frankfurt', 60046, 'Frankfurt am Main');
  insert into banks VALUES ('LAREDEFFXXX', 'Landwirtschaftl Rentenbank', 60014, 'Frankfurt am Main');
  insert into banks VALUES ('FBHLDEFFXXX', 'Credit Europe Bank Ffm', 60050, 'Frankfurt am Main');
  insert into banks VALUES ('BCITDEFFXXX', 'Intesa Sanpaolo Frankfurt', 60011, 'Frankfurt am Main');
  insert into banks VALUES ('INGBDEFFXXX', 'ING Bank Frankfurt', 60486, 'Frankfurt am Main');
  insert into banks VALUES ('FFBKDEFFKRN', 'FIL Fondsbank Frankfurt', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('HCSEDEF1XXX', 'HCBE Frankfurt am Main', 60327, 'Frankfurt am Main');
  insert into banks VALUES ('HKBBDEF1FRA', 'HKB Bank Frankfurt am Main', 60528, 'Frankfurt am Main');
  insert into banks VALUES ('PARBDEFFXXX', 'BNP PARIBAS Sec Serv', 60003, 'Frankfurt am Main');
  insert into banks VALUES ('DWPBDEFFXXX', 'dwpbank', 60487, 'Frankfurt am Main');
  insert into banks VALUES ('ESBKDEFFXXX', 'DenizBank Frankfurt', 60329, 'Frankfurt am Main');
  insert into banks VALUES ('TRODDEF1XXX', 'Triodos Bank Deutschland', 60326, 'Frankfurt am Main');
  insert into banks VALUES ('SCFBDE33XXX', 'Santander Bank Frankfurt', 60325, 'Frankfurt am Main');
  insert into banks VALUES ('ABOCDEFFXXX', 'Agricultural Bank China FRA', 60325, 'Frankfurt am Main');
  insert into banks VALUES ('COBADEFFXXX', 'Commerzbank Frankfurt Main', 60005, 'Frankfurt am Main');
  insert into banks VALUES ('HELADEFFXXX', 'Ld Bk Hess-Thür Gz Ffm', 60297, 'Frankfurt am Main');
  insert into banks VALUES ('HELADEF1822', 'Frankfurter Spk 1822direkt', 60255, 'Frankfurt am Main');
  insert into banks VALUES ('DGZFDEFFXXX', 'DekaBank Frankfurt', 60329, 'Frankfurt am Main');
  insert into banks VALUES ('GENODE55XXX', 'DZ Bank', 60274, 'Frankfurt am Main');
  insert into banks VALUES ('GENODEFFXXX', 'DZ BANK', 60265, 'Frankfurt am Main');
  insert into banks VALUES ('DEUTDEFFXXX', 'Deutsche Bank Frankfurt', 60254, 'Frankfurt am Main');
  insert into banks VALUES ('DEUTDEFFSIP', 'Deutsche Bank F-SIP', 60329, 'Frankfurt am Main');
  insert into banks VALUES ('DEUTDEDBFRA', 'DB PFK (Deutsche Bank PGK)', 60254, 'Frankfurt am Main');
  insert into banks VALUES ('DEUTDE5XXXX', 'Deutsche Bank Europe', 60486, 'Frankfurt am Main');
  insert into banks VALUES ('DRESDEFFXXX', 'Commerzbank Frankfurt', 60613, 'Frankfurt am Main');
  insert into banks VALUES ('GENODEF1S12', 'Sparda-Bank Hessen', 60052, 'Frankfurt am Main');
  insert into banks VALUES ('DAAEDED1007', 'apoBank Frankfurt Main', 60061, 'Frankfurt am Main');
  insert into banks VALUES ('ICBKDEFFXXX', 'ICBC Frankfurt Main', 60322, 'Frankfurt am Main');
  insert into banks VALUES ('DVKBDEFFXXX', 'DVB Frankfurt Main', 60040, 'Frankfurt am Main');
  insert into banks VALUES ('AUSKDEFFXXX', 'AKA Ausfuhrkredit Frankfurt', 60001, 'Frankfurt am Main');
  insert into banks VALUES ('NATXDEFFXXX', 'NATIXIS Frankfurt am Main', 60322, 'Frankfurt am Main');
  insert into banks VALUES ('SCBLDEFXXXX', 'SCB FFM', 60325, 'Frankfurt am Main');
  insert into banks VALUES ('FBGADEF1XXX', 'FBG (D)', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('CHASDEFXXXX', 'J.P. Morgan Frankfurt', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('MAIFDEFFXXX', 'MAINFIRST BANK', 60596, 'Frankfurt am Main');
  insert into banks VALUES ('DELBDE33XXX', 'Bethmann Bank Frankfurt', 60329, 'Frankfurt am Main');
  insert into banks VALUES ('CRESDE55XXX', 'CSD Frankfurt Main', 60310, 'Frankfurt am Main');
  insert into banks VALUES ('COMMDEFFXXX', 'Bank of Communications', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('DOBADEF1XXX', 'VTB Direktbank', 60325, 'Frankfurt am Main');
  insert into banks VALUES ('BPKODEFFXXX', 'PKO Bank Polski Frankfurt', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('NBPADEFFXXX', 'Naba Frankfurt Main', 60313, 'Frankfurt am Main');
  insert into banks VALUES ('MEFIDEMM501', 'Merck Finck Privatbankiers', 60015, 'Frankfurt am Main');
  insert into banks VALUES ('UBSWDEFFXXX', 'UBS Europe', 60079, 'Frankfurt am Main');
  insert into banks VALUES ('ICBVDEFFXXX', 'Vietinbank', 60322, 'Frankfurt am Main');
  insert into banks VALUES ('FFVBDEFFXXX', 'Frankfurter Volksbank', 60008, 'Frankfurt am Main');
  insert into banks VALUES ('GENODE51FHC', 'VB Höchst a.M.Frankfurt alt', 65929, 'Frankfurt am Main');
  insert into banks VALUES ('GENODE51FGH', 'VB Griesheim Ffm -alt-', 65933, 'Frankfurt am Main');
  insert into banks VALUES ('RABODEFFTAR', 'Rabobank Frankfurt Main', 60486, 'Frankfurt am Main');
  insert into banks VALUES ('RABODEFFDIR', 'RaboDirect Frankfurt Main', 60486, 'Frankfurt am Main');
  insert into banks VALUES ('PRCBDEFFXXX', 'ProCredit Bank, Frankfurt', 60486, 'Frankfurt am Main');
  insert into banks VALUES ('CITIDEFFXXX', 'CEP Germany Branch', 60038, 'Frankfurt am Main');
  insert into banks VALUES ('SMHBDEFFXXX', 'UBS Europe', 60020, 'Frankfurt am Main');
  insert into banks VALUES ('INVODEF2XXX', 'Kommunalkredit Deutschland', 60313, 'Frankfurt am Main');
  insert into banks VALUES ('HVBKDEFFXXX', 'WOORI BANK', 60308, 'Frankfurt am Main');
  insert into banks VALUES ('CAIXDEFFXXX', 'CAIXABANK Zndl Frankfurt', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('HAUKDEFFXXX', 'Hauck & Aufhäuser', 60010, 'Frankfurt am Main');
  insert into banks VALUES ('ABCADEFFXXX', 'ABC International Bank Ffm', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('MSPCDEF1XXX', 'Morgan Stanley Bank Int', 60016, 'Frankfurt am Main');
  insert into banks VALUES ('ISBKDEFXXXX', 'Isbank Frankfurt Main', 60022, 'Frankfurt am Main');
  insert into banks VALUES ('METZDEFFXXX', 'Bankhaus Metzler Frankfurt', 60329, 'Frankfurt am Main');
  insert into banks VALUES ('KTAGDEFFXXX', 'KT Bank Frankfurt', 60327, 'Frankfurt am Main');
  insert into banks VALUES ('BARCDEFFXXX', 'Barclays Bank IE, Frankfurt', 60310, 'Frankfurt am Main');
  insert into banks VALUES ('PCBCDEFFXXX', 'CCB Frankfurt', 60078, 'Frankfurt am Main');
  insert into banks VALUES ('OWHBDEFFXXX', 'VTB Bank (Europe) Ffm', 60325, 'Frankfurt am Main');
  insert into banks VALUES ('HYVEDEMM430', 'UniCredit Bank-HypoVereinbk', 60003, 'Frankfurt am Main');
  insert into banks VALUES ('BSCHDEFFXXX', 'Banco Santander Ffm', 60003, 'Frankfurt am Main');
  insert into banks VALUES ('BCMADEFFXXX', 'Attijariwafa bank Frankfurt', 60329, 'Frankfurt am Main');
  insert into banks VALUES ('PICTDEFFXXX', 'Pictet & Cie Europe Ffm', 60311, 'Frankfurt am Main');
  insert into banks VALUES ('FTSBDEFAXXX', 'ABN AMRO Bank', 60325, 'Frankfurt am Main');
  -- 
  -- Daten für Tabelle bp
  insert into bp VALUES (10, 'Jennifer', 'Dresner', 'Neue Roßstr. 73', RPAD(ROUND(RAND()*99999),5,0), 'Feuerhöhe');
  insert into bp VALUES (20, 'Ute', 'Walter', 'Pasewalker Straße 85', RPAD(ROUND(RAND()*99999),5,0), 'Schwalbensumpf');
  insert into bp VALUES (30, 'Peter', 'Bieber', 'Leipziger Strasse 34', RPAD(ROUND(RAND()*99999),5,0), 'Wolfsfurt');
  insert into bp VALUES (40, 'Sebastian', 'Theissen', 'Alt-Moabit 17', RPAD(ROUND(RAND()*99999),5,0), 'Hochstrom');
  insert into bp VALUES (50, 'Anja', 'Nagel', 'Gotzkowskystrasse 56', RPAD(ROUND(RAND()*99999),5,0), 'Fuchssteig');
  insert into bp VALUES (60, 'Janina', 'Lehmann', 'Hoheluftchaussee 2', RPAD(ROUND(RAND()*99999),5,0), 'Schönmeer');
  insert into bp VALUES (70, 'Sven', 'Klein', 'Rohrdamm 32', RPAD(ROUND(RAND()*99999),5,0), 'Kaltenstiege');
  insert into bp VALUES (80, 'Angelika', 'Bar', 'Eichendorffstr. 45', RPAD(ROUND(RAND()*99999),5,0), 'Klingental');
  insert into bp VALUES (90, 'Andreas', 'Trommler', 'Bleibtreustrasse 19', RPAD(ROUND(RAND()*99999),5,0), 'Sonnenberge');
  insert into bp VALUES (100, 'Uta', 'Fideler', 'Genslerstraße 13', RPAD(ROUND(RAND()*99999),5,0), 'Eichenwalde');
  insert into bp VALUES (110, 'Franziska', 'Meier', 'Luckenwalder Strasse 73', RPAD(ROUND(RAND()*99999),5,0), 'Goldwies');
  --
  -- Daten für Tabelle Accounts
  insert into accounts VALUES (200100, 'DXIADEBBXXX', 10, CURRENT_DATE);
  insert into accounts VALUES (500200, 'MEFIDEMM501', 20, CURRENT_DATE);
  insert into accounts VALUES (600300, 'RABODEFFTAR', 30, CURRENT_DATE);
  insert into accounts VALUES (700400, 'DRESDEFFXXX', 40, CURRENT_DATE);
  insert into accounts VALUES (880500, 'HELADEFFXXX', 50, CURRENT_DATE);
  insert into accounts VALUES (990600, 'FBGADEF1XXX', 60, CURRENT_DATE);
  insert into accounts VALUES (110700, 'MARKDEF1500', 70, CURRENT_DATE);
  insert into accounts VALUES (540800, 'AUSKDEFFXXX', 80, CURRENT_DATE);
  insert into accounts VALUES (760900, 'ICBVDEFFXXX', 90, CURRENT_DATE);
  insert into accounts VALUES (244100, 'SMHBDEFFXXX', 100,CURRENT_DATE);
  insert into accounts VALUES (210199, 'ESSEDEFFHAM', 110,CURRENT_DATE);
  --
  -- Daten für Tabelle Saldos
  -- 200100
  insert into saldos VALUES (SaldoSequ.nextval, 200100, 'DXIADEBBXXX', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 200100, 'DXIADEBBXXX', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 200100, 'DXIADEBBXXX', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 200100, 'DXIADEBBXXX', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 200100, 'DXIADEBBXXX', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 200100, 'DXIADEBBXXX', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 200100, 'DXIADEBBXXX', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 200100, 'DXIADEBBXXX', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 200100, 'DXIADEBBXXX', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 200100, 'DXIADEBBXXX', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  -- 500200
  insert into saldos VALUES (SaldoSequ.nextval, 500200, 'MEFIDEMM501', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 500200, 'MEFIDEMM501', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 500200, 'MEFIDEMM501', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 500200, 'MEFIDEMM501', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 500200, 'MEFIDEMM501', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 500200, 'MEFIDEMM501', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 500200, 'MEFIDEMM501', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 500200, 'MEFIDEMM501', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 500200, 'MEFIDEMM501', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 500200, 'MEFIDEMM501', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  -- 600300
  insert into saldos VALUES (SaldoSequ.nextval, 600300, 'RABODEFFTAR', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 600300, 'RABODEFFTAR', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 600300, 'RABODEFFTAR', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 600300, 'RABODEFFTAR', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 600300, 'RABODEFFTAR', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 600300, 'RABODEFFTAR', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 600300, 'RABODEFFTAR', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 600300, 'RABODEFFTAR', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 600300, 'RABODEFFTAR', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 600300, 'RABODEFFTAR', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  -- 700400
  insert into saldos VALUES (SaldoSequ.nextval, 700400, 'DRESDEFFXXX', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 700400, 'DRESDEFFXXX', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 700400, 'DRESDEFFXXX', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 700400, 'DRESDEFFXXX', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 700400, 'DRESDEFFXXX', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 700400, 'DRESDEFFXXX', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 700400, 'DRESDEFFXXX', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 700400, 'DRESDEFFXXX', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 700400, 'DRESDEFFXXX', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 700400, 'DRESDEFFXXX', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  -- 880500
  insert into saldos VALUES (SaldoSequ.nextval, 880500, 'HELADEFFXXX', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 880500, 'HELADEFFXXX', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 880500, 'HELADEFFXXX', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 880500, 'HELADEFFXXX', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 880500, 'HELADEFFXXX', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 880500, 'HELADEFFXXX', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 880500, 'HELADEFFXXX', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 880500, 'HELADEFFXXX', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 880500, 'HELADEFFXXX', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 880500, 'HELADEFFXXX', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  -- 990600'HELADEFFXXX', 
  insert into saldos VALUES (SaldoSequ.nextval, 990600, 'FBGADEF1XXX', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 990600, 'FBGADEF1XXX', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 990600, 'FBGADEF1XXX', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 990600, 'FBGADEF1XXX', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 990600, 'FBGADEF1XXX', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 990600, 'FBGADEF1XXX', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 990600, 'FBGADEF1XXX', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 990600, 'FBGADEF1XXX', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 990600, 'FBGADEF1XXX', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 990600, 'FBGADEF1XXX', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  -- 110700
  insert into saldos VALUES (SaldoSequ.nextval, 110700, 'MARKDEF1500', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 110700, 'MARKDEF1500', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 110700, 'MARKDEF1500', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 110700, 'MARKDEF1500', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 110700, 'MARKDEF1500', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 110700, 'MARKDEF1500', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 110700, 'MARKDEF1500', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 110700, 'MARKDEF1500', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 110700, 'MARKDEF1500', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 110700, 'MARKDEF1500', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  -- 540800
  insert into saldos VALUES (SaldoSequ.nextval, 540800, 'AUSKDEFFXXX', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 540800, 'AUSKDEFFXXX', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 540800, 'AUSKDEFFXXX', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 540800, 'AUSKDEFFXXX', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 540800, 'AUSKDEFFXXX', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 540800, 'AUSKDEFFXXX', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 540800, 'AUSKDEFFXXX', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 540800, 'AUSKDEFFXXX', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 540800, 'AUSKDEFFXXX', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 540800, 'AUSKDEFFXXX', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  -- 760900
  insert into saldos VALUES (SaldoSequ.nextval, 760900, 'ICBVDEFFXXX', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 760900, 'ICBVDEFFXXX', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 760900, 'ICBVDEFFXXX', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 760900, 'ICBVDEFFXXX', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 760900, 'ICBVDEFFXXX', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 760900, 'ICBVDEFFXXX', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 760900, 'ICBVDEFFXXX', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 760900, 'ICBVDEFFXXX', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 760900, 'ICBVDEFFXXX', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 760900, 'ICBVDEFFXXX', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  -- 244100
  insert into saldos VALUES (SaldoSequ.nextval, 244100, 'SMHBDEFFXXX', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 244100, 'SMHBDEFFXXX', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 244100, 'SMHBDEFFXXX', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 244100, 'SMHBDEFFXXX', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 244100, 'SMHBDEFFXXX', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 244100, 'SMHBDEFFXXX', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 244100, 'SMHBDEFFXXX', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 244100, 'SMHBDEFFXXX', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 244100, 'SMHBDEFFXXX', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 244100, 'SMHBDEFFXXX', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  -- 210199
  insert into saldos VALUES (SaldoSequ.nextval, 210199, 'ESSEDEFFHAM', '20190131', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 210199, 'ESSEDEFFHAM', '20190228', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 210199, 'ESSEDEFFHAM', '20190331', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 210199, 'ESSEDEFFHAM', '20190430', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 210199, 'ESSEDEFFHAM', '20190531', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 210199, 'ESSEDEFFHAM', '20190630', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 210199, 'ESSEDEFFHAM', '20190731', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 210199, 'ESSEDEFFHAM', '20190831', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 210199, 'ESSEDEFFHAM', '20190930', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  insert into saldos VALUES (SaldoSequ.nextval, 210199, 'ESSEDEFFHAM', '20191031', NULL, 'EUR', ROUND(TO_DECIMAL(1+(99999-1)*RAND()),2)); -- generate primary key by sequence SaldoSequ
  --
  -- Daten für Tabelle Transactions
  -- 200100
  insert into transactions VALUES (TrnsSequ.nextval, 200100, 'DXIADEBBXXX', '20191001', 'EUR', 3500); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 200100, 'DXIADEBBXXX', '20191002', 'EUR', -500); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 200100, 'DXIADEBBXXX', '20191005', 'EUR', -300); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 200100, 'DXIADEBBXXX', '20191008', 'EUR', 150); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 200100, 'DXIADEBBXXX', '20191025', 'EUR', -1000); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 200100, 'DXIADEBBXXX', '20191026', 'EUR', -5); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 200100, 'DXIADEBBXXX', '20191030', 'EUR', 25); -- generate primary key by sequence TrnsSequ
  -- 500200
  insert into transactions VALUES (TrnsSequ.nextval, 500200, 'MEFIDEMM501', '20191009', 'EUR', -300); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 500200, 'MEFIDEMM501', '20191011', 'EUR', -150); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 500200, 'MEFIDEMM501', '20191014', 'EUR', 50); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 500200, 'MEFIDEMM501', '20191018', 'EUR', 33); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 500200, 'MEFIDEMM501', '20191020', 'EUR', -25); -- generate primary key by sequence TrnsSequ
  -- 600300
  insert into transactions VALUES (TrnsSequ.nextval, 600300, 'RABODEFFTAR', '20190503', 'EUR', 130); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 600300, 'RABODEFFTAR', '20190520', 'EUR', -30); -- generate primary key by sequence TrnsSequ
  insert into transactions VALUES (TrnsSequ.nextval, 600300, 'RABODEFFTAR', '20190523', 'EUR', -10); -- generate primary key by sequence TrnsSequ