API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 9th, 2018
581
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.55 KB | None | 0 0
raw download clone embed print report
  1. insert into Seminar
  2. value(1,'2013-10-12','11:00:00','San Antonio Convention Center','Kitchen on a Budget');
  3. insert into Seminar
  4. value(2,'2013-10-26','16:00:00','Dallas Convention Center','Kitchen on a Big D Budget');
  5. insert into Seminar
  6. value(3,'2013-11-02','08:30:00','Austin Convention Center','Kitchen on a Budget');
  7. insert into Seminar
  8. value(4,'2014-03-22','11:00:00','Dallas Convention Center ','Kitchen on a Big D Budget');
  9. insert into Seminar
  10. value(5,'2014-03-24','11:00:00','Dallas Convention Center','Kitchen on a Big D Budget');
  11. insert into Seminar
  12. value(6,'2014-04-05','08:30:00',' Austin Convention Center','Kitchen on a Budget');
  13.  
  14. INSERT INTO INVOICE
  15. VALUE (35000, '2013-10-15', 3, "VISA", 22.94, 5.95, 1.31, 30.20);
  16. INSERT INTO INVOICE
  17. VALUE (35001, '2013-10-25', 4, "MasterCard", 47.89, 5.95, 2.73, 56.57);
  18. INSERT INTO INVOICE
  19. VALUE (35002, '2013-12-20', 7, "VISA", 24.95, 5.95, 1.42, 32.32);
  20. INSERT INTO INVOICE
  21. VALUE (35003, '2014-03-25', 4, "MasterCard", 64.85, 5.95, 3.70, 74.50);
  22. INSERT INTO INVOICE
  23. VALUE (35004, '2014-03-27', 6, "MasterCard", 94.79, 5.95, 5.40, 106.14);
  24. INSERT INTO INVOICE
  25. VALUE (35005, '2014-03-27', 7, "MasterCard", 94.80, 5.95, 5.40, 106.15);
  26. INSERT INTO INVOICE
  27. VALUE (35006, '2014-03-31', 9, "VISA", 47.89, 5.95, 2.73, 56.57);
  28. INSERT INTO INVOICE
  29. VALUE (35007, '2014-04-03', 11, "MasterCard", 109.78, 5.95, 6.26, 121.99);
  30. INSERT INTO INVOICE
  31. VALUE (35008, '2014-04-08', 5, "MasterCard", 47.89, 5.95, 2.73, 56.57);
  32. INSERT INTO INVOICE
  33. VALUE (35009, '2014-04-08', 1, "VISA", 47.89, 5.95, 2.73, 56.57);
  34. INSERT INTO INVOICE
  35. VALUE (35010, '2014-04-23', 3, "VISA", 24.95, 5.95, 1.42, 32.32);
  36. INSERT INTO INVOICE
  37. VALUE (35011, '2014-05-07', 9, "VISA", 22.94, 5.95, 1.31, 30.20);
  38. INSERT INTO INVOICE
  39. VALUE (35012, '2014-05-21', 8, "MasterCard", 54.89, 5.95, 3.13, 63.97);
  40. INSERT INTO INVOICE
  41. VALUE (35013, '2014-06-05', 3, "VISA", 47.89, 5.95, 2.73, 56.57);
  42. INSERT INTO INVOICE
  43. VALUE (35014, '2014-06-05', 11, "MasterCard", 45.88, 5.95, 2.62, 54.45);
  44. INSERT INTO INVOICE
  45. VALUE (35015, '2014-06-05', 12, "MasterCard", 94.79, 5.95, 5.40, 106.14);
  46. INSERT INTO INVOICE
  47. VALUE (35016, '2014-06-05', 3, "VISA", 45.88, 5.95, 2.62, 54.45);
  48.  
  49.  
  50. insert into PRODUCT
  51. value( "BK001", "Book", "Kitchen Remodeling Basics For Everyone", 24.95, 75);
  52. insert into PRODUCT
  53. value ( "BK002", "Book", "Advanced Kitchen Remodeling For Everyone", 24.95, 75);
  54. insert into PRODUCT
  55. value ("BK003", "Book", "Kitchen Remodeling Dallas Style For Everyone", 24.95, 75);
  56. insert into PRODUCT
  57. value ( "VB001", "Video Companion", "Kitchen Remodling Basics", 7.99, 50);
  58. insert into PRODUCT
  59. value ("VB002", "Video Companion", "Advanced Kitchen Remodeling", 7.99, 35);
  60. insert into PRODUCT
  61. value ("VB003", "Video Companion", "Kitchen Remodeling Dallas Style", 9.95, 25);
  62. insert into PRODUCT
  63. value ("VK001", "Video", "Kitchen Remodeling Basics", 14.95, 50);
  64. insert into PRODUCT
  65. value ("VK002", "Video", "Advanced Kitchen Remodeling", 14.95,35);
  66. insert into PRODUCT
  67. value ("VK003", "Video", "Kitchen Remodeling Dallas Style", 19.95, 25);
  68. insert into PRODUCT
  69. value ("VK004", "Video", "Heather Sweeney Seminar Live in Dallas on 25-OCT-13", 24.95, 20);
  70.  
  71.  
  72. insert into Seminar_Customer
  73. value(1,1);
  74. insert into Seminar_Customer
  75. value(1,2);
  76. insert into Seminar_Customer
  77. value(1,3);
  78. insert into Seminar_Customer
  79. value(1,4);
  80. insert into Seminar_Customer
  81. value(1,5);
  82. insert into Seminar_Customer
  83. value(2,6);
  84. insert into Seminar_Customer
  85. value(4,6);
  86. insert into Seminar_Customer
  87. value(2,7);
  88. insert into Seminar_Customer
  89. value(4,7);
  90. insert into Seminar_Customer
  91. value(2,8);
  92. insert into Seminar_Customer
  93. value(3,9);
  94. insert into Seminar_Customer
  95. value(3,10);
  96. insert into Seminar_Customer
  97. value(4,11);
  98. insert into Seminar_Customer
  99. value(4,12);
  100.  
  101.  
  102. INSERT INTO CUSTOMER
  103. VALUE(1, 'Jacobs', 'Nancy', "Nancy.Jacobs@somewhere.com", "nf46tG9E", "817-871-8123", "1440 West Palm Drive", "Fort Worth", "TX", "76110");
  104. INSERT INTO CUSTOMER
  105. VALUE(2, 'Jacobs', 'Chantel', "Chantel.Jacobs@somewhere.com", "b65TG03f, 817-871-8234", "1550 East Palm Drive", "Fort Worth", "TX", "76112");
  106. INSERT INTO CUSTOMER
  107. VALUE(3, 'Able', 'Ralph', "Ralph.Able@somewhere.com", "m56fGH08", "210-281-7987, 123 Elm Street", "San Antonio", "TX", "78214");
  108. INSERT INTO CUSTOMER
  109. VALUE(4, 'Baker', 'Susan', "Susan.Baker@elsewhere.com", "PC93fEk9", "210-281-7876, 456 Oak Street", "San Antonio", "TX", "78216");
  110. INSERT INTO CUSTOMER
  111. VALUE(5, 'Eagleton', 'Sam', "Sam.Eagleton@elsewhere.com", "bnvR44W8", "210-281-7765", "789 Pine Street", "San Antonio", "TX", "78218");
  112. INSERT INTO CUSTOMER
  113. VALUE(6, 'Foxtrot', 'Kathy', "Kathy.Foxtrot@somewhere.com", "aa8tY4GL", "972-233-6234", "11023 Elm Street", "Dallas", "TX", "75220");
  114. INSERT INTO CUSTOMER
  115. VALUE(7, 'George', 'Sally', "Sally.George@somewhere.com", "LK8G2tyF", "972-233-6345", "12034 San Jacinto", "Dallas", "TX", "75223");
  116. INSERT INTO CUSTOMER
  117. VALUE(8, 'Hullett', 'Shawn', "Shawn.Hullett@elsewhere.com", "bu78WW3t", "972-233-6456", "13045 Flora", "Dallas", "TX", "75224");
  118. INSERT INTO CUSTOMER
  119. VALUE(9, 'Pearson', 'Bobbi', "Bobbi.Pearson@elsewhere.com", "kq6N2O0p", "512-974-3344", "43 West 23rd Street", "Auston", "TX", "78710");
  120. INSERT INTO CUSTOMER
  121. VALUE(10, 'Ranger', 'Terry', "Terry.Ranger@somewhere.com", "bv3F9Qc4", "512-974-4455", "56 East 18th Street", "Auston", "TX", "78712");
  122. INSERT INTO CUSTOMER
  123. VALUE(11, 'Tyler', 'Jenny', "Jenny.Tyler@somewhere.com", "Yu4be77Z", "972-233-6567", "14056", "South Ervay Street", "Dallas", "TX", "75225");
  124. INSERT INTO CUSTOMER
  125. VALUE(12, 'Wayne', 'Joan', "Joan.Wayne@elsewhere.com", "JW4TX6g", "817-871-8245", "1660 South Aspen Drive", "Fort Worth", "TX", "76115");
  126.  
  127. INSERT INTO LINE_ITEM
  128. VALUE (35000, 1, "VK001", 1, 14.95, 14.95);
  129. INSERT INTO LINE_ITEM
  130. VALUE (35000, 2, "VB001", 1, 7.99, 7.99);
  131. INSERT INTO LINE_ITEM
  132. VALUE (35001, 1, "VK001", 1, 14.95, 14.95);
  133. INSERT INTO LINE_ITEM
  134. VALUE (35001, 2, "VB001", 1, 7.99, 7.99);
  135. INSERT INTO LINE_ITEM
  136. VALUE (35001, 3, "BK001", 1, 24.95, 24.95);
  137. INSERT INTO LINE_ITEM
  138. VALUE (35002, 1, "VK004", 1, 24.95, 24.95);
  139. INSERT INTO LINE_ITEM
  140. VALUE (35003, 1, "VK002", 1, 14.95, 14.95);
  141. INSERT INTO LINE_ITEM
  142. VALUE (35003, 2, "BK002", 1, 24.95, 24.95);
  143. INSERT INTO LINE_ITEM
  144. VALUE (35003, 3, "VK004", 1, 24.95, 24.95);
  145. INSERT INTO LINE_ITEM
  146. VALUE (35004, 1, "VK002", 1, 14.95, 14.95);
  147. INSERT INTO LINE_ITEM
  148. VALUE (35004, 2, "BK002", 1, 24.95, 24.95);
  149. INSERT INTO LINE_ITEM
  150. VALUE (35004, 3, "VK003", 1, 19.95, 19.95);
  151. INSERT INTO LINE_ITEM
  152. VALUE (35004, 4, "VB003", 1, 9.99, 9.99);
  153. INSERT INTO LINE_ITEM
  154. VALUE (35004, 5, "VK004", 1, 24.95, 24.95);
  155. INSERT INTO LINE_ITEM
  156. VALUE (35005, 1, "BK001", 1, 24.95, 24.95);
  157. INSERT INTO LINE_ITEM
  158. VALUE (35005, 2, "BK002", 1, 24.95, 24.95);
  159. INSERT INTO LINE_ITEM
  160. VALUE (35005, 3, "VK003", 1, 19.95, 19.95);
  161. INSERT INTO LINE_ITEM
  162. VALUE (35005, 4, "VK004", 1, 24.95, 24.95);
  163. INSERT INTO LINE_ITEM
  164. VALUE (35006, 1, "BK001", 1, 24.95, 24.95);
  165. INSERT INTO LINE_ITEM
  166. VALUE (35006, 2, "VK001", 1, 14.95, 14.95);
  167. INSERT INTO LINE_ITEM
  168. VALUE (35006, 3, "VB001", 1, 7.99, 7.99);
  169. INSERT INTO LINE_ITEM
  170. VALUE (35007, 1, "VK003", 2, 19.95, 39.90);
  171. INSERT INTO LINE_ITEM
  172. VALUE (35007, 2, "VB003", 2, 9.99, 19.98);
  173. INSERT INTO LINE_ITEM
  174. VALUE (35007, 3, "VK004", 2, 24.95, 49.90);
  175. INSERT INTO LINE_ITEM
  176. VALUE (35008, 1, "BK001", 1, 24.95, 24.95);
  177. INSERT INTO LINE_ITEM
  178. VALUE (35008, 2, "VK001", 1, 14.95, 14.95);
  179. INSERT INTO LINE_ITEM
  180. VALUE (35008, 3, "VB001", 1, 7.99, 7.99);
  181. INSERT INTO LINE_ITEM
  182. VALUE (35009, 1, "BK001", 1, 24.95, 24.95);
  183. INSERT INTO LINE_ITEM
  184. VALUE (35009, 2, "VK001", 1, 14.95, 14.95);
  185. INSERT INTO LINE_ITEM
  186. VALUE (35009, 3, "VB001", 1, 7.99, 7.99);
  187. INSERT INTO LINE_ITEM
  188. VALUE (35010, 1, "BK001", 1, 24.95, 24.95);
  189. INSERT INTO LINE_ITEM
  190. VALUE (35011, 1, "VK002", 1, 14.95, 14.95);
  191. INSERT INTO LINE_ITEM
  192. VALUE (35011, 2, "VB002", 1, 7.99, 7.99);
  193. INSERT INTO LINE_ITEM
  194. VALUE (35012, 1, "VK003", 1, 19.95, 19.95);
  195. INSERT INTO LINE_ITEM
  196. VALUE (35012, 2, "VB003", 1, 9.99, 9.99);
  197. INSERT INTO LINE_ITEM
  198. VALUE (35012, 3, "VK004", 1, 24.95, 24.95);
  199. INSERT INTO LINE_ITEM
  200. VALUE (35013, 1, "VK002", 1, 14.95, 14.95);
  201. INSERT INTO LINE_ITEM
  202. VALUE (35013, 2, "VB002", 1, 7.99, 7.99);
  203. INSERT INTO LINE_ITEM
  204. VALUE (35013, 3, "BK002", 1, 24.95, 24.95);
  205. INSERT INTO LINE_ITEM
  206. VALUE (35014, 1, "VK002", 2, 14.95, 29.90);
  207. INSERT INTO LINE_ITEM
  208. VALUE (35014, 2, "VB002", 2, 7.99, 15.98);
  209. INSERT INTO LINE_ITEM
  210. VALUE (35015, 1, "VK002", 1, 14.95, 14.95);
  211. INSERT INTO LINE_ITEM
  212. VALUE (35015, 2, "BK002", 1, 24.95, 24.95);
  213. INSERT INTO LINE_ITEM
  214. VALUE (35015, 3, "VK003", 1, 19.95, 19.95);
  215. INSERT INTO LINE_ITEM
  216. VALUE (35015, 4, "VB003", 1, 9.99, 9.99);
  217. INSERT INTO LINE_ITEM
  218. VALUE (35015, 5, "VK004", 1, 24.95, 24.95);
  219. INSERT INTO LINE_ITEM
  220. VALUE (35016, 1, "VK001", 1, 14.95, 14.95);
  221. INSERT INTO LINE_ITEM
  222. VALUE (35016, 2, "VB001", 1, 7.99, 7.99);
  223. INSERT INTO LINE_ITEM
  224. VALUE (35016, 3, "VK002", 1, 14.95, 14.95);
  225. INSERT INTO LINE_ITEM
  226. VALUE (35016, 4, "VB002", 1, 7.99, 7.99);
  227.  
  228. INSERT INTO CONTACT
  229. value(1,1,2013-10-12,Seminar,1);
  230. INSERT INTO CONTACT
  231. value(1,2,2013-10-15,EmailSeminarMessage,NULL);
  232. INSERT INTO CONTACT
  233. value(1,3,2013-10-15,FormLetterSeminar,NULL);
  234. INSERT INTO CONTACT
  235. value(2,1,2013-10-12,Seminar,1);
  236. INSERT INTO CONTACT
  237. value(2,2,2013-10-15,EmailSeminarMessage,NULL);
  238. INSERT INTO CONTACT
  239. value(2,3,2013-10-15,FormLetterSeminar,NULL);
  240. INSERT INTO CONTACT
  241. value(3,1,2013-10-12,Seminar,1);
  242. INSERT INTO CONTACT
  243. value(3,2,2013-10-15,EmailSeminarMessage,NULL);
  244. INSERT INTO CONTACT
  245. value(3,3,2013-10-15,FormLetterSeminar,NULL);
  246. INSERT INTO CONTACT
  247. value(3,4,2014-02-20,WebAccountCreation,NULL);
  248. INSERT INTO CONTACT
  249. value(3,5,2014-02-20,EmailAccountMessage,NULL);
  250. INSERT INTO CONTACT
  251. value(4,1,2013-10-12,Seminar,1);
  252. INSERT INTO CONTACT
  253. value(4,2,2013-10-15,EmailSeminarMessage,NULL);
  254. INSERT INTO CONTACT
  255. value(4,3,2013-10-15,FormLetterSeminar,NULL);
  256. INSERT INTO CONTACT
  257. value(5,1,2013-10-12,Seminar,1);
  258. INSERT INTO CONTACT
  259. value(5,2,2013-10-15,EmailSeminarMessage,NULL);
  260. INSERT INTO CONTACT
  261. value(5,3,2013-10-15,FormLetterSeminar,NULL);
  262. INSERT INTO CONTACT
  263. value(6,1,2013-10-26,Seminar,2);
  264. INSERT INTO CONTACT
  265. value(6,2,2013-10-30,EmailSeminarMessage,NULL);
  266. INSERT INTO CONTACT
  267. value(6,3,2013-10-30,FormLetterSeminar,NULL);
  268. INSERT INTO CONTACT
  269. value(6,4,2014-02-22,WebAccountCreation,NULL);
  270. INSERT INTO CONTACT
  271. value(6,5,2014-02-22,EmailAccountMessage,NULL);
  272. INSERT INTO CONTACT
  273. value(6,6,2014-03-22,Seminar,4);
  274. INSERT INTO CONTACT
  275. value(7,1,2013-10-26,Seminar,2);
  276. INSERT INTO CONTACT
  277. value(7,2,2013-10-30,EmailSeminarMessage,NULL);
  278. INSERT INTO CONTACT
  279. value(7,3,2013-10-30,FormLetterSeminar,NULL);
  280. INSERT INTO CONTACT
  281. value(7,4,2014-02-25,WebAccountCreation,NULL);
  282. INSERT INTO CONTACT
  283. value(7,5,2014-02-25,EmailAccountMessage,NULL);
  284. INSERT INTO CONTACT
  285. value(7,6,2014-03-22,Seminar,4);
  286. INSERT INTO CONTACT
  287. value(8,1,2013-10-26,Seminar,2);
  288. INSERT INTO CONTACT
  289. value(8,2,2013-10-30,EmailSeminarMessage,NULL);
  290. INSERT INTO CONTACT
  291. value(8,3,2013-10-30,FormLetterSeminar,NULL);
  292. INSERT INTO CONTACT
  293. value(8,4,2014-03-07,WebAccountCreation,NULL);
  294. INSERT INTO CONTACT
  295. value(8,5,2014-03-07,EmailAccountMessage,NULL);
  296. INSERT INTO CONTACT
  297. value(9,1,2013-11-02,Seminar,3);
  298. INSERT INTO CONTACT
  299. value(9,2,2013-11-06,EmailSeminarMessage,NULL);
  300. INSERT INTO CONTACT
  301. value(9,3,2013-11-06,FormLetterSeminar,NULL);
  302. INSERT INTO CONTACT
  303. value(10,1,2013-11-02,Seminar,3);
  304. INSERT INTO CONTACT
  305. value(10,2,2013-11-06,EmailSeminarMessage,NULL);
  306. INSERT INTO CONTACT
  307. value(10,3,2013-11-06,FormLetterSeminar,NULL);
  308. INSERT INTO CONTACT
  309. value(11,1,2014-03-22,Seminar,4);
  310. INSERT INTO CONTACT
  311. value(12,1,2014-03-22,Seminar,4);
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!