API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 8th, 2018
199
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.00 KB | None | 0 0
raw download clone embed print report
  1. set echo off
  2.  
  3. prompt #-----------------------#
  4. prompt #- Smazat vsechna data -#
  5. prompt #-----------------------#
  6.  
  7. exec VYMAZ_DATA_VSECH_TABULEK;
  8.  
  9. prompt #----------------------#
  10. prompt #- Vypnout cizi klice -#
  11. prompt #----------------------#
  12.  
  13. exec VYPNI_CIZI_KLICE;
  14.  
  15. prompt #---------------#
  16. prompt #- Vlozit data -#
  17. prompt #---------------#
  18.  
  19. prompt Tabulka ADRESS
  20.  
  21. begin
  22. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (1, 'Malšice', 17,39175, 'Okružní');
  23. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (2, 'Hluboké Mašůvky', 50,67152, 'Seifertova');
  24. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (3, 'Hostišová', 31,76301,'Radinova');
  25. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (4, 'Libuň', 26,50715,'Kollárova');
  26. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (5, 'Štítary', 2,67102,'Bizoní');
  27. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (6, 'Chrustenice', 7,26712,'Letní');
  28. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (7, 'Tužice', 357,34142,'Palachovo');
  29. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (8, 'Tužice', 75,34142,'Nebeského klidu');
  30. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (9, 'Podhradní Lhota', 3,76871,'J.V.Sládka');
  31. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (10, 'Praha', 552,14000,'Evropská','Smilkova');
  32. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (11, 'Krchleby', 1,78901,'Abrahámova');
  33. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (12, 'Rokytnice', 1,76321,'Jiráskova');
  34. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (13, 'Černovice', 29,34562,'Kmentova');
  35. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (14, 'Karlovy Vary', 476,25070, 'Korunní');
  36. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (15, 'Karlovy Vary', 50,67152, 'Jabloňová');
  37. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (16, 'Liberec', 425,57201, 'Habrová');
  38. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (17, 'Liberec', 938,34543, 'Habrová');
  39. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (18, 'Klamoš', 101,50351,'Cibulkova');
  40. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (19, 'Únešov', 71,33036,'Hánova');
  41. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (20, 'Kalvody', 63,27054,'Slivoňova');
  42. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (21, 'Šťáhlava', 49,33203,'Hradní');
  43. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (22, 'Vimperk', 371,56301,'Zelená');
  44. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (23, 'Vimperk', 165,53862,'Budičovská');
  45. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (24, 'Zlín', 274,34901,'Pivovarská');
  46. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (25, 'Zlín', 803,35601,'Hřbitovní');
  47. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (26, 'Olomouc', 573,78401, 'Polská');
  48. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (27, 'Olomouc', 196,34901, 'Okružní');
  49. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (28, 'Olomouc', 897,33032,'Polská');
  50. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (29, 'Lučany nad Nisou', 45,46871,'Vlčí');
  51. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (30, 'Klatovy', 565,66902,'Pražská');
  52. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (31, 'Klatovy', 139,53901,'Pod Hůrkou');
  53. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (32, 'Rakovník', 497,25765, 'Kollárova');
  54. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (33, 'Lišov', 123,37372,'Cardova');
  55. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (34, 'Kamenec', 419,53701,'Smejkalova');
  56. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (35, 'Hradec Králové', 349,50002, 'Dědkova');
  57. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (36, 'Hradec Králové', 149,50002, 'Jedlová');
  58. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (37, 'Hradec Králové', 472,50002, 'Mařákova');
  59. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (38, 'Jílové', 87,40502,'Holubí');
  60. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (39, 'Nové Dvory', 19,59212,'Na Smetišti');
  61. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (40, 'Praha', 333,19011,'Balbínova');
  62. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (41, 'Praha', 336,11300,'Bachmačské náměstí');
  63. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (42, 'Praha', 952,17900,'Arabská');
  64. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (43, 'Praha', 995,20300,'Evropská');
  65. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (44, 'Praha', 302,20000,'Farská');
  66. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (45, 'Praha', 634,13500,'Kolářova');
  67. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (46, 'Praha', 389,10700,'Korunní');
  68. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (47, 'Praha', 467,16200,'Lednová');
  69. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (48, 'Praha', 490,10400,'Dukelská');
  70. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (49, 'Plzeň', 528,10000,'Kotlářka');
  71. insert into Adress (ID_Adress, City, House_number, Postal Code, Street) values (0, 'Praha', 546,58301,'Americká');
  72. end;
  73. /
  74.  
  75. prompt Tabulka CASE_TYPE
  76.  
  77. begin
  78. insert into CASE_TYPE (ID_CASE_TYPE, INPUT, DESCRIPTION, Price/h, TYPE_NAME) values (0, 2500, 'Běžné vyšetřování, dostatečně popsaný problém, potenciální vyšetření do několika dnů, postačí 1 detektiv',150,'běžné');
  79. insert into CASE_TYPE (ID_CASE_TYPE, INPUT, DESCRIPTION, Price/h, TYPE_NAME) values (1, 0, 'Výpomoc policii, žádný počáteční vklad, policie detektivy platí sama',200,'výpomoc policii');
  80. insert into CASE_TYPE (ID_CASE_TYPE, INPUT, DESCRIPTION, Price/h, TYPE_NAME) values (2, 7500, 'Méně informací, nejasný popis případu od klienta, potenciál vyřešení do několika týdnů',180,'Středně obtížné');
  81. insert into CASE_TYPE (ID_CASE_TYPE, INPUT, DESCRIPTION, Price/h, TYPE_NAME) values (3, 20000, 'Málo informací, důkazů, potenciál vyřešení do několika měsíců, doporučené nasazení více detektivů',210,'Obtížné');
  82. insert into CASE_TYPE (ID_CASE_TYPE, INPUT, DESCRIPTION, Price/h, TYPE_NAME) values (4, 35000, 'Téměř žádné informace a důkazy, neurčitý potenciál vyřešení, nasazení části oddělení', 250,'Extrémně obtížné');
  83. end;
  84. /
  85.  
  86. prompt Tabulka CCASE
  87.  
  88. begin
  89. insert into CCASE (ID_CASE, RECORD_DATE, STATE, CASE_TYPE_ID_CASE_TYPE, CLIENT_PERSON_ID_PERSON, DESCRIPTION, CASE_NAME) values (0, to_date(06-FEB-97),'uzavřený', 1, 0, 'Rozšíření desinformace o viru v internetovém bankovnictví komerční banky. Desetitisíce uživatelů zaplavilo stránky KB s cílem zkontrolovat zda-li jejich účet nebyl napaden, přičemž došlo ke shození serveru www.kb.cz a následnému vykradení tisíců účtů. Jeden z pachatelů zastřelil svého komplice ','Útok na Komerční banku');
  90. insert into CCASE (ID_CASE, RECORD_DATE, STATE, CASE_TYPE_ID_CASE_TYPE, CLIENT_PERSON_ID_PERSON, DESCRIPTION, CASE_NAME) values (1, to_date(19-AUG-06),'otevřený', 2, 1, 'Dvojnásobná vražda mladého páru, neznámý útočník','Dvojnásobná vražda mladého páru');
  91. insert into CCASE (ID_CASE, RECORD_DATE, STATE, CASE_TYPE_ID_CASE_TYPE, CLIENT_PERSON_ID_PERSON, DESCRIPTION, CASE_NAME) values (2, to_date(24-APR-00),'otevřený', 0, 2, 'Noční vyloupení obchodního domu Tesco v Praze 4, pachatel zaznamenán na kameru','Loupež Tesco Praha 4');
  92. insert into CCASE (ID_CASE, RECORD_DATE, STATE, CASE_TYPE_ID_CASE_TYPE, CLIENT_PERSON_ID_PERSON, DESCRIPTION, CASE_NAME) values (3, to_date(20-SEP-08),'uzavřený', 1, 3, 'Největší krádež v historii ČR. Zaměstnanec bezpečnostní agentury během směny ukradl půl miliardy','Největší loupež v ČR');
  93. insert into CCASE (ID_CASE, RECORD_DATE, STATE, CASE_TYPE_ID_CASE_TYPE, CLIENT_PERSON_ID_PERSON, DESCRIPTION, CASE_NAME) values (4, to_date(14-JUL-04),'otevřený', 2, 4, 'Hledání pachatele který přejel cyklistu a ujel z místa nehody, započaté na přání matky oběti','Smrt cyklisty');
  94. end;
  95. /
  96.  
  97. prompt Tabulka CRIME
  98.  
  99. begin
  100. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (3,to_date(09-JUL-08),'Cukrovka a rakovina jsou vymyšlené nemoci',2,'Spreading_fake_news');
  101. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (4,to_date(12-MAR-92),'Ubodání důchodkyně',9,'Murder');
  102. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (5,to_date(27-MAY-05),'Vražda desetiletého chlapce',10,'Murder');
  103. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (0,to_date(05-FEB-97),'Šíření poplašné zprávy o viru na serveru Komerční banky',3,'Spreading_fake_news');
  104. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (1,to_date(06-FEB-97),'Hackerský útok na servery KB',7,'Theft');
  105. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (2,to_date(08-FEB-97),'Vražda Komplice',8,'Murder');
  106. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (6,to_date(11-NOV-13),'Vykradení obchodního domu Tesco',3,'Theft');
  107. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (7,to_date(21-FEB-96),'Vražda mladého muže, věk 24 let',8,'Murder');
  108. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (8,to_date(21-FEB-96),'Vražda mladé ženy, věk 23 let',8,'Murder');
  109. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (9,to_date(20-SEP-08),'Největší krádež v ČR',8,'Theft');
  110. insert into CRIME (ID_CRIME, CRIME_DATE, DESCRIPTION, SEVERITY, CRIME_TYPE) values (10,to_date(10-JUL-04),'Řidič srazil cyklistu, který na následky svých zranění zemřel',7,'Murder');
  111. end;
  112. /
  113.  
  114. prompt Tabulka MURDER
  115.  
  116. begin
  117. insert into MURDER (ID_CRIME, AGRESSION_RATE) values (2,6);
  118. insert into MURDER (ID_CRIME, AGRESSION_RATE) values (4,10);
  119. insert into MURDER (ID_CRIME, AGRESSION_RATE) values (5,9);
  120. insert into MURDER (ID_CRIME, AGRESSION_RATE) values (7,10);
  121. insert into MURDER (ID_CRIME, AGRESSION_RATE) values (8,6);
  122. insert into MURDER (ID_CRIME, AGRESSION_RATE) values (10,4);
  123. end;
  124. /
  125.  
  126. prompt Tabulka SPREADING_FAKE_NEWS
  127.  
  128. begin
  129. insert into SPREADING_FAKE_NEWS (ID_CRIME,Non-objectivity_degree,SPREADING_FREQUENCY) values (3,5,8);
  130. insert into SPREADING_FAKE_NEWS (ID_CRIME,Non-objectivity_degree,SPREADING_FREQUENCY) values (0,6,9);
  131.  
  132. end;
  133. /
  134.  
  135. prompt Tabulka THEFT
  136.  
  137. begin
  138. insert into THEFT (ID_CRIME, FINANCIAL_HARM) values (1,18000000);
  139. insert into THEFT (ID_CRIME, FINANCIAL_HARM) values (6,100000);
  140. insert into THEFT (ID_CRIME, FINANCIAL_HARM) values (9,540000000);
  141. end;
  142. /
  143.  
  144. prompt Tabulka PERSON
  145.  
  146. begin
  147. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(0,'Mojmír','Franek',0);
  148. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(1,'František','Vácha',1);
  149. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(2,'Robin','Schmied',2);
  150. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(3,'Zbyšek','Mocek',3);
  151. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(4,'Makvartová','Izabela',4);
  152. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(5,'Blahoslav','Juchelka',5);
  153. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(6,'Anastázie','Hýblová',6);
  154. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(7,'Lubor','Martinec',7);
  155. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(8,'Marián','Březina',8);
  156. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(9,'Julie','Princová',9);
  157. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(10,'Ilona','Konrádová',(null));
  158. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(11,'Anděla','Vodičková',(null));
  159. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(12,'Ivo','Vilímek',(null));
  160. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(13,'Jan','Jarolím',13);
  161. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(14,'Miroslav','Vach',14);
  162. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(15,'Renáta','Dolečková',15);
  163. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(16,'Svatoslav','Kaňák',16);
  164. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(17,'Bruno','Moučka',17);
  165. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(18,'Ester','Škvorová',18);
  166. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(19,'Luboš','Zikmund',19);
  167. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(20,'Iveta','Uhlířová',20);
  168. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(21,'Petr','Froněk',21);
  169. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(22,'Viktor','Machálek',22);
  170. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(23,'Izabela','Sekerová',23);
  171. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(24,'Jakub','Šustek',24);
  172. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(25,'Květa','Dobešová',25);
  173. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(26,'Ivan','Makvart',26);
  174. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(27,'Anežka','Knopová',27);
  175. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(28,'Marika','Wernerová',28);
  176. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(29,'Diana','Zieglerová',29);
  177. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(30,'Ema','Zieglerová',29);
  178. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(31,'Zbyšek','Ziegler',29);
  179. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(32,'Lubor','Šimánek',20);
  180. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(33,'Ivana','Uhlířová',44);
  181. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(34,'Štefan','Hejna',45);
  182. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(35,'Arnošt','Pavlas',45);
  183. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(36,'Evelína','Kozlíková',46);
  184. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(37,'Jan','Doubek',47);
  185. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(38,'Jaroslava','Vránová',48);
  186. insert into PERSON (ID_PERSON, FIRSTNAME, SURNAME, ADRESS_ID_ADRESS) values(39,'Valentýn','Martinovský',49);
  187. end;
  188. /
  189.  
  190. prompt Tabulka CLIENT
  191.  
  192. begin
  193. insert into CLIENT (EMAIL, PHONE_NUMBER, PERSON_ID_PERSON) values ('mojmir196@email.cz', 777666555,0);
  194. insert into CLIENT (EMAIL, PHONE_NUMBER, PERSON_ID_PERSON) values ('vachy.franta1@email.cz', 731967667,1);
  195. insert into CLIENT (EMAIL, PHONE_NUMBER, PERSON_ID_PERSON) values ('rob.schmied@seznam.cz', 733933333,2);
  196. insert into CLIENT (EMAIL, PHONE_NUMBER, PERSON_ID_PERSON) values ('zbysekzbysek@tiscali.cz', 776123456,3);
  197. insert into CLIENT (EMAIL, PHONE_NUMBER, PERSON_ID_PERSON) values ('makybela@centrum.cz', 603015015,4);
  198. end;
  199. /
  200.  
  201. prompt Tabulka CRIMINAL
  202.  
  203. begin
  204. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(10,'na svobodě',(null),'Hnědá');
  205. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(11,'dopaden','Zelená','Blond');
  206. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(12,'na svobodě','Hnědá',(null));
  207. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(5,'dopaden','Modrá','Černá');
  208. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(6,'dopaden','Modrá','Hnědá');
  209. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(7,'na svobodě','Zelená',(null));
  210. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(8,'dopaden','Hnědá','Hnědá');
  211. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(9,'mrtev','Modrá','Blond');
  212. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(20,'mrtev','Hnědá','Blond');
  213. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(21,'dopaden','Zelená','Černá');
  214. insert into CRIMINAL (PERSON_ID_PERSON, STATE, EYE_COLOR, HAIR_COLOR) values(22,'dopaden','Hnědá','Černá');
  215. end;
  216. /
  217.  
  218. prompt Tabulka DETECTIVE
  219.  
  220. begin
  221. insert into CRIMINAL (EMAIL, EMPLOYED_FROM, PERSON_ID_PERSON) values('marval@eyeofcrime.cz',to_date(01-JAN-89),39);
  222. insert into CRIMINAL (EMAIL, EMPLOYED_FROM, PERSON_ID_PERSON) values('vrajar@eyeofcrime.cz',to_date(12-MAR-90),38);
  223. insert into CRIMINAL (EMAIL, EMPLOYED_FROM, PERSON_ID_PERSON) values('doujan@eyeofcrime.cz',to_date(17-FEB-90),37);
  224. insert into CRIMINAL (EMAIL, EMPLOYED_FROM, PERSON_ID_PERSON) values('kozeve@eyeofcrime.cz',to_date(13-MAY-99),36);
  225. insert into CRIMINAL (EMAIL, EMPLOYED_FROM, PERSON_ID_PERSON) values('pavarn@eyeofcrime.cz',to_date(02-JAN-94),35);
  226. insert into CRIMINAL (EMAIL, EMPLOYED_FROM, PERSON_ID_PERSON) values('sekiza@eyeofcrime.cz',to_date(03-NOV-07),23);
  227. insert into CRIMINAL (EMAIL, EMPLOYED_FROM, PERSON_ID_PERSON) values('susjak@eyeofcrime.cz',to_date(30-JUL-06),24);
  228. insert into CRIMINAL (EMAIL, EMPLOYED_FROM, PERSON_ID_PERSON) values('dobkve@eyeofcrime.cz',to_date(22-APR-01),25);
  229. end;
  230. /
  231.  
  232. prompt Tabulka VICTIM
  233.  
  234. begin
  235. insert into VICTIM (BIRTHDATE, RELATIONSHIP_TO_MURDERER, CAUSE_OF_DEATH, PERSON_ID_PERSON, MURDER_ID_CRIME) values ('25-MAY-95','kamarád','Smrt po úderu kladivem',13,5);
  236. insert into VICTIM (BIRTHDATE, RELATIONSHIP_TO_MURDERER, CAUSE_OF_DEATH, PERSON_ID_PERSON, MURDER_ID_CRIME) values ('07-DEC-46','kamarád','Vykrvácení, způsobené bodnými ranami',15,4);
  237. insert into VICTIM (BIRTHDATE, RELATIONSHIP_TO_MURDERER, CAUSE_OF_DEATH, PERSON_ID_PERSON, MURDER_ID_CRIME) values ('29-AUG-76','kamarád','Střelná rána prošla skrz hlavou',9,2);
  238. insert into VICTIM (BIRTHDATE, RELATIONSHIP_TO_MURDERER, CAUSE_OF_DEATH, PERSON_ID_PERSON, MURDER_ID_CRIME) values ('17-JUL-92','kamarád','Přejetí automobilem',26,2);
  239. end;
  240. /
  241.  
  242. prompt Tabulka COMMITTING
  243.  
  244. begin
  245. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (5,5);
  246. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (7,3);
  247. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (6,9);
  248. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (8,4);
  249. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (8,2);
  250. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (10,7);
  251. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (11,8);
  252. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (12,2);
  253. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (20,6);
  254. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (21,6);
  255. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (22,6);
  256. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (9,1);
  257. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (9,0);
  258. insert into COMMITTING (CRIME_ID_PERSON, CRIME_ID_CRIME) values (8,0);
  259. end;
  260. /
  261.  
  262. prompt Tabulka CONNECTION
  263.  
  264. begin
  265. insert into CONNECTION (CASE_ID_CASE, CRIME_ID_CRIME) values (0,0);
  266. insert into CONNECTION (CASE_ID_CASE, CRIME_ID_CRIME) values (0,1);
  267. insert into CONNECTION (CASE_ID_CASE, CRIME_ID_CRIME) values (0,2);
  268. insert into CONNECTION (CASE_ID_CASE, CRIME_ID_CRIME) values (1,7);
  269. insert into CONNECTION (CASE_ID_CASE, CRIME_ID_CRIME) values (1,8);
  270. insert into CONNECTION (CASE_ID_CASE, CRIME_ID_CRIME) values (2,6);
  271. insert into CONNECTION (CASE_ID_CASE, CRIME_ID_CRIME) values (4,10);
  272. insert into CONNECTION (CASE_ID_CASE, CRIME_ID_CRIME) values (3,9);
  273.  
  274. end;
  275. /
  276.  
  277. prompt Tabulka INVESTIGATION
  278.  
  279. begin
  280. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (37,0);
  281. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (38,0);
  282. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (35,3);
  283. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (36,3);
  284. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (37,3);
  285. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (38,3);
  286. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (39,3);
  287. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (35,1);
  288. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (36,1);
  289. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (35,2);
  290. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (38,2);
  291. insert into INVESTIGATIN (DETECTIVE_ID_PERSON, CASE_ID_CASE) values (39,2);
  292. end;
  293. /
  294.  
  295. commit;
  296.  
  297. prompt #----------------------#
  298. prompt #- Zapnout cizi klice -#
  299. prompt #----------------------#
  300.  
  301. exec ZAPNI_CIZI_KLICE;
  302.  
  303. prompt #------------------------------#
  304. prompt #- Statistiky a pocty zaznamu -#
  305. prompt #------------------------------#
  306.  
  307. begin
  308. -- napln?me hodnoty do sloupce NUM_ROWS v pohledu USER_TABLES (metadata v datov?m slovn?ku)
  309. DBMS_STATS.GATHER_SCHEMA_STATS(ownname => user, estimate_percent => 100);
  310. end;
  311. /
  312.  
  313. column TABLE_NAME format A40;
  314. set pagesize 0;
  315. select TABLE_NAME, NUM_ROWS from USER_TABLES order by TABLE_NAME;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!