DDL FOr Table: create table TASK_MASTER ( TASKID NUMBER not null, TASKDESC VARCHAR2(50 CHAR), MANHRS NUMBER(8), PROPOSED_START_DATE DATE, PROPOSED_ENDDATE DATE, ACTUAL_START_DATE DATE, ACTUAL_END_DATE DATE, DASHBOARD VARCHAR2(1 CHAR), STATUS VARCHAR2(1 CHAR), MAKERID VARCHAR2(8 CHAR), MAKEDATE DATE ); Sample Data: insert into task_master (TASKID, TASKDESC, MANHRS, PROPOSED_START_DATE, PROPOSED_ENDDATE, ACTUAL_START_DATE, ACTUAL_END_DATE, DASHBOARD, STATUS, MAKERID, MAKEDATE) values (311, 'Bug fixing', 10, to_date('23-03-2009', 'dd-mm-yyyy'), to_date('23-03-2009', 'dd-mm-yyyy'), to_date('23-03-2009', 'dd-mm-yyyy'), to_date('23-03-2009', 'dd-mm-yyyy'), 'Y', 'A', '', null); insert into task_master (TASKID, TASKDESC, MANHRS, PROPOSED_START_DATE, PROPOSED_ENDDATE, ACTUAL_START_DATE, ACTUAL_END_DATE, DASHBOARD, STATUS, MAKERID, MAKEDATE) values (308, 'IslamicLM', 20, to_date('05-05-2009', 'dd-mm-yyyy'), to_date('08-05-2009', 'dd-mm-yyyy'), to_date('05-05-2009', 'dd-mm-yyyy'), to_date('08-05-2009', 'dd-mm-yyyy'), 'N', 'A', '', null); insert into task_master (TASKID, TASKDESC, MANHRS, PROPOSED_START_DATE, PROPOSED_ENDDATE, ACTUAL_START_DATE, ACTUAL_END_DATE, DASHBOARD, STATUS, MAKERID, MAKEDATE) values (329, 'taskmaster', 21, to_date('23-03-2009', 'dd-mm-yyyy'), to_date('24-03-2009', 'dd-mm-yyyy'), to_date('25-03-2009', 'dd-mm-yyyy'), to_date('26-03-2009', 'dd-mm-yyyy'), 'N', 'A', '', null); insert into task_master (TASKID, TASKDESC, MANHRS, PROPOSED_START_DATE, PROPOSED_ENDDATE, ACTUAL_START_DATE, ACTUAL_END_DATE, DASHBOARD, STATUS, MAKERID, MAKEDATE) values (330, 'File upload', 15, to_date('23-03-2009', 'dd-mm-yyyy'), to_date('23-03-2009', 'dd-mm-yyyy'), to_date('26-03-2009', 'dd-mm-yyyy'), to_date('26-03-2009', 'dd-mm-yyyy'), 'Y', 'A', '', null); insert into task_master (TASKID, TASKDESC, MANHRS, PROPOSED_START_DATE, PROPOSED_ENDDATE, ACTUAL_START_DATE, ACTUAL_END_DATE, DASHBOARD, STATUS, MAKERID, MAKEDATE) values (309, 'Test', 111, to_date('05-03-2009', 'dd-mm-yyyy'), to_date('18-03-2010', 'dd-mm-yyyy'), to_date('06-03-2009', 'dd-mm-yyyy'), to_date('07-03-2009', 'dd-mm-yyyy'), 'Y', 'X', '', null); insert into task_master (TASKID, TASKDESC, MANHRS, PROPOSED_START_DATE, PROPOSED_ENDDATE, ACTUAL_START_DATE, ACTUAL_END_DATE, DASHBOARD, STATUS, MAKERID, MAKEDATE) values (310, 'Employeee', 2, to_date('05-03-2009', 'dd-mm-yyyy'), to_date('06-03-2009', 'dd-mm-yyyy'), to_date('05-03-2009', 'dd-mm-yyyy'), to_date('06-03-2009', 'dd-mm-yyyy'), 'Y', 'A', '', null); insert into task_master (TASKID, TASKDESC, MANHRS, PROPOSED_START_DATE, PROPOSED_ENDDATE, ACTUAL_START_DATE, ACTUAL_END_DATE, DASHBOARD, STATUS, MAKERID, MAKEDATE) values (349, 'Test the all masters', 22, to_date('23-03-2009', 'dd-mm-yyyy'), to_date('23-03-2009', 'dd-mm-yyyy'), to_date('24-03-2009', 'dd-mm-yyyy'), to_date('24-03-2009', 'dd-mm-yyyy'), 'Y', 'A', '', null); insert into task_master (TASKID, TASKDESC, MANHRS, PROPOSED_START_DATE, PROPOSED_ENDDATE, ACTUAL_START_DATE, ACTUAL_END_DATE, DASHBOARD, STATUS, MAKERID, MAKEDATE) values (350, 'Client Master', 16, to_date('23-03-2009', 'dd-mm-yyyy'), to_date('24-03-2009', 'dd-mm-yyyy'), to_date('25-03-2009', 'dd-mm-yyyy'), to_date('25-03-2009', 'dd-mm-yyyy'), 'Y', 'A', '', null);