CREATE TABLE work.WORK_table
(
  WORK_ID           NUMBER,
  WORK_DATE         DATE,
  ROUTE             NUMBER(3),
  RUN               NUMBER(3),
  ON_TIME           NUMBER(4),
  OFF_TIME          NUMBER(4),
  START_DT          DATE,
  FINISH_DT         DATE
);

INSERT INTO WORK.WORK_table ( WORK_ID, WORK_DATE, ROUTE, RUN, ON_TIME, OFF_TIME, START_DT,
FINISH_DT ) VALUES ( 1,
 TO_Date( '07/19/2011 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 1, 2, 2350, 2655,  TO_Date( '07/19/2011 11:50:00 PM', 'MM/DD/YYYY HH:MI:SS AM')
,  TO_Date( '07/20/2011 02:55:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO WORK.WORK_table( WORK_ID, WORK_DATE, ROUTE, RUN, ON_TIME, OFF_TIME, START_DT,
FINISH_DT ) VALUES ( 2, 
 TO_Date( '07/19/2011 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 2, 3, 2430, 2700,  TO_Date( '07/20/2011 12:30:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
,  TO_Date( '07/20/2011 03:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO WORK.WORK_table ( WORK_ID, WORK_DATE, ROUTE, RUN, ON_TIME, OFF_TIME, START_DT,
FINISH_DT ) VALUES ( 3, 
 TO_Date( '07/19/2011 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 4, 5, 2515, 2700,  TO_Date( '07/20/2011 01:15:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
,  TO_Date( '07/20/2011 03:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO WORK.WORK_table ( WORK_ID, WORK_DATE, ROUTE, RUN, ON_TIME, OFF_TIME, START_DT,
FINISH_DT ) VALUES ( 4, 
 TO_Date( '07/19/2011 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 5, 6, 2245, 2545,  TO_Date( '07/19/2011 10:45:00 PM', 'MM/DD/YYYY HH:MI:SS AM')
,  TO_Date( '07/20/2011 01:45:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO WORK.WORK_table( WORK_ID, WORK_DATE, ROUTE, RUN, ON_TIME, OFF_TIME, START_DT,
FINISH_DT ) VALUES ( 5, 
 TO_Date( '07/19/2011 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 7, 8, 2359, 2700,  TO_Date( '07/19/2011 11:59:00 PM', 'MM/DD/YYYY HH:MI:SS AM')
,  TO_Date( '07/20/2011 03:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 

COMMIT;

--Here is what we get when we run the script

WORK_ID	WORK_DATE	ROUTE RUN		ON_TIME OFF_TIME	START_DT					FINISH_DT 
1		2011-Jul-19	 1		2		2350	2655		2011-Jul-19 11:50:00 PM		2011-Jul-20 2:55:00 AM 
2		2011-Jul-19	 2		3		2430	2700		2011-Jul-20 12:30:00 AM		2011-Jul-20 3:00:00 AM 
3		2011-Jul-19	 4		5		2515	2700		2011-Jul-20 1:15:00 AM		2011-Jul-20 3:00:00 AM 
4		2011-Jul-19	 5		6		2245	2545		2011-Jul-19 10:45:00 PM		2011-Jul-20 1:45:00 AM 
5		2011-Jul-19  7		8		2359	2700		2011-Jul-19 11:59:00 PM		2011-Jul-20 3:00:00 AM