Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement