CREATE TABLE OT_JOB_DET
(
  JT_TXN       VARCHAR2(12 BYTE),
  JT_NO        NUMBER,
  JT_DT        DATE,
  JT_EMP_CODE  VARCHAR2(6 BYTE),
  JT_DURATION  NUMBER
)/


INSERT INTO OT_JOB_DET ( JT_TXN, JT_NO, JT_DT, JT_EMP_CODE,
JT_DURATION ) VALUES ( 
'time', 1,  TO_Date( '11/04/2012 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 'AA', 10); 
INSERT INTO OT_JOB_DET ( JT_TXN, JT_NO, JT_DT, JT_EMP_CODE,
JT_DURATION ) VALUES ( 
'time', 2,  TO_Date( '11/01/2012 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 'AA', 12); 
INSERT INTO OT_JOB_DET ( JT_TXN, JT_NO, JT_DT, JT_EMP_CODE,
JT_DURATION ) VALUES ( 
'time', 3,  TO_Date( '11/09/2012 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 'BB', 7); 
INSERT INTO OT_JOB_DET ( JT_TXN, JT_NO, JT_DT, JT_EMP_CODE,
JT_DURATION ) VALUES ( 
'time', 4,  TO_Date( '11/14/2012 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 'CC', 2.43); 
INSERT INTO OT_JOB_DET ( JT_TXN, JT_NO, JT_DT, JT_EMP_CODE,
JT_DURATION ) VALUES ( 
'time', 5,  TO_Date( '11/15/2012 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 'DD', 2); 
COMMIT;


first output


SELECT  JT_DT,SUM(JT_DURATION)FROM
OT_JOB_DET GROUP BY JT_DT;

SELECT JT_EMP_CODE ,SUM(JT_DURATION) FROM
OT_JOB_DET GROUP BY JT_EMP_CODE;