Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

Abdullah Dogan

By: a guest on Jan 20th, 2010  |  syntax: Oracle 8  |  size: 3.22 KB  |  views: 182  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. CREATE TABLE t_signal
  2. (
  3. signal_id VARCHAR2(7),
  4. signal_status VARCHAR2(4),
  5. signal_date DATE
  6. );
  7.  
  8.  
  9.  
  10. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  11. VALUES ('SS1', 'down', TO_DATE('19-11-2009 16:29:00', 'dd-mm-yyyy hh24:mi:ss'));
  12.  
  13. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  14. VALUES ('SS2', 'down', TO_DATE('19-11-2009 16:29:00', 'dd-mm-yyyy hh24:mi:ss'));
  15.  
  16. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  17. VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:04', 'dd-mm-yyyy hh24:mi:ss'));
  18.  
  19. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  20. VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:05', 'dd-mm-yyyy hh24:mi:ss'));
  21.  
  22. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  23. VALUES ('SS2', 'down', TO_DATE('19-11-2009 16:29:07', 'dd-mm-yyyy hh24:mi:ss'));
  24.  
  25. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  26. VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:08', 'dd-mm-yyyy hh24:mi:ss'));
  27.  
  28. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  29. VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:12', 'dd-mm-yyyy hh24:mi:ss'));
  30.  
  31. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  32. VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:14', 'dd-mm-yyyy hh24:mi:ss'));
  33.  
  34. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  35. VALUES ('SS1', 'down', TO_DATE('19-11-2009 16:29:16', 'dd-mm-yyyy hh24:mi:ss'));
  36.  
  37. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  38. VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:18', 'dd-mm-yyyy hh24:mi:ss'));
  39.  
  40. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  41. VALUES ('SS1', 'down', TO_DATE('19-11-2009 16:29:19', 'dd-mm-yyyy hh24:mi:ss'));
  42.  
  43. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  44. VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:22', 'dd-mm-yyyy hh24:mi:ss'));
  45.  
  46. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  47. VALUES ('SS2', 'down', TO_DATE('19-11-2009 16:29:24', 'dd-mm-yyyy hh24:mi:ss'));
  48.  
  49. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  50. VALUES ('SS1', 'down', TO_DATE('19-11-2009 16:29:25', 'dd-mm-yyyy hh24:mi:ss'));
  51.  
  52. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  53. VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:28', 'dd-mm-yyyy hh24:mi:ss'));
  54.  
  55. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  56. VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:28', 'dd-mm-yyyy hh24:mi:ss'));
  57.  
  58. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  59. VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:29', 'dd-mm-yyyy hh24:mi:ss'));
  60.  
  61. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  62. VALUES ('SS2', 'down', TO_DATE('19-11-2009 16:29:32', 'dd-mm-yyyy hh24:mi:ss'));
  63.  
  64. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  65. VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:35', 'dd-mm-yyyy hh24:mi:ss'));
  66.  
  67. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  68. VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:36', 'dd-mm-yyyy hh24:mi:ss'));
  69.  
  70. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  71. VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:38', 'dd-mm-yyyy hh24:mi:ss'));
  72.  
  73. INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
  74. VALUES ('SS1', 'down', TO_DATE('19-11-2009 16:29:40', 'dd-mm-yyyy hh24:mi:ss'));