CREATE TABLE t_signal
(
signal_id VARCHAR2(7),
signal_status VARCHAR2(4),
signal_date DATE
);
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'down', TO_DATE('19-11-2009 16:29:00', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'down', TO_DATE('19-11-2009 16:29:00', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:04', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:05', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'down', TO_DATE('19-11-2009 16:29:07', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:08', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:12', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:14', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'down', TO_DATE('19-11-2009 16:29:16', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:18', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'down', TO_DATE('19-11-2009 16:29:19', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:22', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'down', TO_DATE('19-11-2009 16:29:24', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'down', TO_DATE('19-11-2009 16:29:25', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:28', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:28', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:29', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'down', TO_DATE('19-11-2009 16:29:32', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'up', TO_DATE('19-11-2009 16:29:35', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:36', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS2', 'up', TO_DATE('19-11-2009 16:29:38', 'dd-mm-yyyy hh24:mi:ss'));
INSERT INTO t_signal (signal_ID, signal_STATUS, signal_DATE)
VALUES ('SS1', 'down', TO_DATE('19-11-2009 16:29:40', 'dd-mm-yyyy hh24:mi:ss'));