API tools faq
paste
Advertisement
saleks28

SUBD2_8sem

saleks28
Sep 23rd, 2020
1,974
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Oracle 11 11.24 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO Software VALUES (5555, 'Windows', 'Proprietary', 999.99);
  2. INSERT INTO Software VALUES (3333, 'Ubuntu', 'GNU GPL', 0.0);
  3. INSERT INTO Software VALUES (100, 'Minesweeper', NULL, NULL);
  4. INSERT INTO Software VALUES (20, 'Winamp', 'Proprietary', 0.0);
  5. INSERT INTO Software VALUES (15, 'Debian', 'GNU GPL', 0.0);
  6. INSERT INTO Software VALUES (30, 'Office Word', 'Proprietary', 50.0);
  7. INSERT INTO Software VALUES (1, 'MS-DOS', 'Proprietary', NULL);
  8. INSERT INTO Software VALUES (10, 'Office Excel', 'Proprietary', 50.99);
  9. INSERT INTO Software VALUES (3, 'ALT Linux', 'Freeware', 0.0);
  10. INSERT INTO Software VALUES (110, 'Google Chrome', 'Freeware', 0.0);
  11. INSERT INTO Software VALUES (5, 'VMware ESX', 'Proprietary', 12200.0);
  12. INSERT INTO Software VALUES (120, 'Mozilla Firefox', 'GNU GPL', 0.0);
  13. INSERT INTO Software VALUES (125, 'Wireshark', 'GNU GPL 2+', 0.0);
  14. INSERT INTO Software VALUES (50, 'Skype', 'Freemium', 20.0);
  15. INSERT INTO Software VALUES (75, 'AVG Internet Security', 'Freemium', 200.0);
  16. INSERT INTO Software VALUES (85, 'CMake', 'New BSD License', 0.0);
  17. INSERT INTO Software VALUES (95, 'PyCharm', 'Freemium', 0.0);
  18. INSERT INTO Software VALUES (60, 'Notepad++', 'GNU GPL 2', 0.0);
  19. INSERT INTO Software VALUES (90, 'iTunes', 'Proprietary', 105.0);
  20. INSERT INTO Software VALUES (150, 'Thunderbird', 'GNU GPL 2', 0.0);
  21. INSERT INTO Software VALUES (220, 'Adobe Acrobat Reader', 'Proprietary', 100.0);
  22. INSERT INTO Software VALUES (45, 'WinRAR', 'Trialware', 120.0);
  23. INSERT INTO Software VALUES (190, 'Adobe Photoshop', 'Freemium', 0.0);
  24. INSERT INTO Software VALUES (65, 'Visual Studio', 'Proprietary', 600.0);
  25.  
  26. INSERT INTO Computer_System VALUES (10001, 'CS1', 'Server');
  27. INSERT INTO Computer_System VALUES (10002, 'CS2', 'Server');
  28. INSERT INTO Computer_System VALUES (10003, 'CS3', 'PC');
  29. INSERT INTO Computer_System VALUES (10004, 'CS4', 'PC');
  30. INSERT INTO Computer_System VALUES (10005, 'CS5', 'PC');
  31. INSERT INTO Computer_System VALUES (10006, 'CS6', 'PC');
  32. INSERT INTO Computer_System VALUES (10007, 'CS7', 'Net');
  33. INSERT INTO Computer_System VALUES (10008, 'CS8', 'Net');
  34. INSERT INTO Computer_System VALUES (10009, 'CS9', 'Admin');
  35. INSERT INTO Computer_System VALUES (10010, 'CS10', 'Security');
  36.  
  37. INSERT INTO Software_Computer_System VALUES(5555, 10003);
  38. INSERT INTO Software_Computer_System VALUES(5555, 10004);
  39. INSERT INTO Software_Computer_System VALUES(5555, 10006);
  40. INSERT INTO Software_Computer_System VALUES(5555, 10001);
  41. INSERT INTO Software_Computer_System VALUES(3333, 10005);
  42. INSERT INTO Software_Computer_System VALUES(3333, 10009);
  43. INSERT INTO Software_Computer_System VALUES(100, 10003);
  44. INSERT INTO Software_Computer_System VALUES(100, 10004);
  45. INSERT INTO Software_Computer_System VALUES(100, 10006);
  46. INSERT INTO Software_Computer_System VALUES(20, 10003);
  47. INSERT INTO Software_Computer_System VALUES(20, 10004);
  48. INSERT INTO Software_Computer_System VALUES(15, 10007);
  49. INSERT INTO Software_Computer_System VALUES(15, 10008);
  50. INSERT INTO Software_Computer_System VALUES(30, 10003);
  51. INSERT INTO Software_Computer_System VALUES(30, 10004);
  52. INSERT INTO Software_Computer_System VALUES(30, 10001);
  53. INSERT INTO Software_Computer_System VALUES(10, 10004);
  54. INSERT INTO Software_Computer_System VALUES(10, 10003);
  55. INSERT INTO Software_Computer_System VALUES(10, 10006);
  56. INSERT INTO Software_Computer_System VALUES(3, 10010);
  57. INSERT INTO Software_Computer_System VALUES(110, 10003);
  58. INSERT INTO Software_Computer_System VALUES(110, 10004);
  59. INSERT INTO Software_Computer_System VALUES(110, 10006);
  60. INSERT INTO Software_Computer_System VALUES(5, 10002);
  61. INSERT INTO Software_Computer_System VALUES(120, 10005);
  62. INSERT INTO Software_Computer_System VALUES(120, 10009);
  63. INSERT INTO Software_Computer_System VALUES(120, 10007);
  64. INSERT INTO Software_Computer_System VALUES(120, 10008);
  65. INSERT INTO Software_Computer_System VALUES(125, 10003);
  66. INSERT INTO Software_Computer_System VALUES(125, 10004);
  67. INSERT INTO Software_Computer_System VALUES(125, 10005);
  68. INSERT INTO Software_Computer_System VALUES(125, 10006);
  69. INSERT INTO Software_Computer_System VALUES(125, 10009);
  70. INSERT INTO Software_Computer_System VALUES(125, 10010);
  71. INSERT INTO Software_Computer_System VALUES(50, 10003);
  72. INSERT INTO Software_Computer_System VALUES(50, 10004);
  73. INSERT INTO Software_Computer_System VALUES(50, 10006);
  74. INSERT INTO Software_Computer_System VALUES(75, 10003);
  75. INSERT INTO Software_Computer_System VALUES(75, 10004);
  76. INSERT INTO Software_Computer_System VALUES(75, 10006);
  77. INSERT INTO Software_Computer_System VALUES(75, 10001);
  78. INSERT INTO Software_Computer_System VALUES(85, 10003);
  79. INSERT INTO Software_Computer_System VALUES(85, 10004);
  80. INSERT INTO Software_Computer_System VALUES(85, 10005);
  81. INSERT INTO Software_Computer_System VALUES(85, 10006);
  82. INSERT INTO Software_Computer_System VALUES(85, 10010);
  83. INSERT INTO Software_Computer_System VALUES(95, 10005);
  84. INSERT INTO Software_Computer_System VALUES(60, 10003);
  85. INSERT INTO Software_Computer_System VALUES(60, 10004);
  86. INSERT INTO Software_Computer_System VALUES(60, 10006);
  87. INSERT INTO Software_Computer_System VALUES(60, 10001);
  88. INSERT INTO Software_Computer_System VALUES(90, 10003);
  89. INSERT INTO Software_Computer_System VALUES(90, 10004);
  90. INSERT INTO Software_Computer_System VALUES(90, 10006);
  91. INSERT INTO Software_Computer_System VALUES(150, 10003);
  92. INSERT INTO Software_Computer_System VALUES(150, 10004);
  93. INSERT INTO Software_Computer_System VALUES(150, 10005);
  94. INSERT INTO Software_Computer_System VALUES(150, 10006);
  95. INSERT INTO Software_Computer_System VALUES(150, 10007);
  96. INSERT INTO Software_Computer_System VALUES(150, 10008);
  97. INSERT INTO Software_Computer_System VALUES(150, 10009);
  98. INSERT INTO Software_Computer_System VALUES(150, 10010);
  99. INSERT INTO Software_Computer_System VALUES(220, 10003);
  100. INSERT INTO Software_Computer_System VALUES(220, 10004);
  101. INSERT INTO Software_Computer_System VALUES(220, 10006);
  102. INSERT INTO Software_Computer_System VALUES(45, 10003);
  103. INSERT INTO Software_Computer_System VALUES(45, 10004);
  104. INSERT INTO Software_Computer_System VALUES(45, 10006);
  105. INSERT INTO Software_Computer_System VALUES(65, 10003);
  106. INSERT INTO Software_Computer_System VALUES(65, 10004);
  107. INSERT INTO Software_Computer_System VALUES(65, 10006);
  108.  
  109. INSERT INTO SystemSoft VALUES (5555, HEXTORAW('18FCF74BE90C3EBD8279CA1F1BC5DEAD'));
  110. INSERT INTO SystemSoft VALUES (3333, HEXTORAW('DEADFCF08279C74BE918ADFC3EB1BC51'));
  111. INSERT INTO SystemSoft VALUES (15, HEXTORAW('9CA181F1F7E94D1EADBFC270C8BC53EB'));
  112. INSERT INTO SystemSoft VALUES (1, HEXTORAW('08FC133785A6412CABF5A130201FBEE1'));
  113. INSERT INTO SystemSoft VALUES (3, HEXTORAW('ABF55A64FBC1337EE120181208FCA130'));
  114. INSERT INTO SystemSoft VALUES (5, HEXTORAW('E1201C13ABF537E645AF8FCA13B81200'));
  115. INSERT INTO SystemSoft VALUES (125, NULL);
  116. INSERT INTO SystemSoft VALUES (75, NULL);
  117. INSERT INTO SystemSoft VALUES (85, NULL);
  118. INSERT INTO SystemSoft VALUES (65, NULL);
  119. INSERT INTO SystemSoft VALUES (95, NULL);
  120.  
  121. INSERT INTO Applications VALUES (45, 'Trialware file archiver utility for Windows, developed by Eugene Roshal of win.rar GmbH', 'File archiver');
  122. INSERT INTO Applications VALUES (100, 'Minesweeper is a single-player puzzle video game', 'Game');
  123. INSERT INTO Applications VALUES (20, 'Media player for Windows, macOS and Android, originally developed by Justin Frankel and Dmitry Boldyrev', 'Media player');
  124. INSERT INTO Applications VALUES (30, 'Word processor developed by Microsoft', 'Word processor');
  125. INSERT INTO Applications VALUES (10, 'Spreadsheet developed by Microsoft for Windows, macOS, Android and iOS', 'Spreadsheet');
  126. INSERT INTO Applications VALUES (110, 'Сross-platform web browser developed by Google', 'Web browser');
  127. INSERT INTO Applications VALUES (120, 'Free and open-source web browser developed by the Mozilla Foundation and its subsidiary, Mozilla Corporation', 'Web browser');
  128. INSERT INTO Applications VALUES (50, 'Telecommunications application that specializes in providing video chat and voice calls between computers, smartwatches over the Internet', 'Instant messaging');
  129. INSERT INTO Applications VALUES (60, 'Text and source code editor for use with Microsoft Windows', 'Source code editor');
  130. INSERT INTO Applications VALUES (90, 'media player, media library, Internet radio broadcaster, mobile device management utility, and the client app for iTunes Store, developed by Apple Inc', 'Media player');
  131. INSERT INTO Applications VALUES (150, 'Free and open-source, cross-platform email client, news client, RSS, and chat client developed by the Mozilla Foundation', 'Email client');
  132. INSERT INTO Applications VALUES (220, 'Application software developed by Adobe Inc. to view, create, manipulate, print and manage files in Portable Document Format', 'Desktop publishing');
  133. INSERT INTO Applications VALUES (190, 'Raster graphics editor developed and published by Adobe Inc. for Windows and macOS', 'Raster graphics editor');
  134.  
  135. INSERT INTO Applications_SystemSoft VALUES (45, 5555);
  136. INSERT INTO Applications_SystemSoft VALUES (100, 5555);
  137. INSERT INTO Applications_SystemSoft VALUES (30, 5555);
  138. INSERT INTO Applications_SystemSoft VALUES (10, 5555);
  139. INSERT INTO Applications_SystemSoft VALUES (110, 5555);
  140. INSERT INTO Applications_SystemSoft VALUES (50, 5555);
  141. INSERT INTO Applications_SystemSoft VALUES (90, 5555);
  142. INSERT INTO Applications_SystemSoft VALUES (60, 5555);
  143. INSERT INTO Applications_SystemSoft VALUES (150, 5555);
  144. INSERT INTO Applications_SystemSoft VALUES (220, 5555);
  145. INSERT INTO Applications_SystemSoft VALUES (120, 5555);
  146. INSERT INTO Applications_SystemSoft VALUES (120, 3333);
  147. INSERT INTO Applications_SystemSoft VALUES (150, 3333);
  148. INSERT INTO Applications_SystemSoft VALUES (120, 15);
  149. INSERT INTO Applications_SystemSoft VALUES (150, 15);
  150. -- Для 3 запроса
  151. INSERT INTO Applications_SystemSoft VALUES (120, 1);
  152. INSERT INTO Applications_SystemSoft VALUES (150, 1);
  153. INSERT INTO Applications_SystemSoft VALUES (120, 3);
  154. INSERT INTO Applications_SystemSoft VALUES (150, 3);
  155. INSERT INTO Applications_SystemSoft VALUES (120, 5);
  156. INSERT INTO Applications_SystemSoft VALUES (150, 5);
  157. INSERT INTO Applications_SystemSoft VALUES (120, 125);
  158. INSERT INTO Applications_SystemSoft VALUES (150, 125);
  159. INSERT INTO Applications_SystemSoft VALUES (120, 75);
  160. INSERT INTO Applications_SystemSoft VALUES (150, 75);
  161. INSERT INTO Applications_SystemSoft VALUES (120, 85);
  162. INSERT INTO Applications_SystemSoft VALUES (150, 85);
  163. INSERT INTO Applications_SystemSoft VALUES (120, 65);
  164. INSERT INTO Applications_SystemSoft VALUES (150, 65);
  165. INSERT INTO Applications_SystemSoft VALUES (120, 95);
  166. INSERT INTO Applications_SystemSoft VALUES (150, 95);
  167.  
  168. INSERT INTO CS_Component VALUES (8, 10007, 'Pink', 1, NULL);
  169. INSERT INTO CS_Component VALUES (9, 10007, 'Yellow', 2, NULL);
  170. INSERT INTO CS_Component VALUES (10, 10010, 'White', 4, NULL);
  171. INSERT INTO CS_Component VALUES (11, 10010, 'Black', 4, NULL);
  172. INSERT INTO CS_Component VALUES (12, 10010, 'Blue', 5, NULL);
  173. INSERT INTO CS_Component VALUES (1, 10001, 'Red', 6, 8);
  174. INSERT INTO CS_Component VALUES (2, 10001, 'Red', NULL, 8);
  175. INSERT INTO CS_Component VALUES (3, 10002, 'Yellow', 8, 8);
  176. INSERT INTO CS_Component VALUES (4, 10002, 'Brown', 9, 8);
  177. INSERT INTO CS_Component VALUES (5, 10003, 'Ground', 4, 11);
  178. INSERT INTO CS_Component VALUES (6, 10004, 'White', 11, 11);
  179. INSERT INTO CS_Component VALUES (7, 10005, 'Green', 12, 11);
  180.  
  181.  
  182.  
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!