CREATE TABLE TEST_CASE
(
  EMP_ID      VARCHAR2(255 BYTE),
  EMP_TYPE    VARCHAR2(255 BYTE),
  START_DATE  DATE,
  END_DATE    DATE,
  TOT_SAL     VARCHAR2(255 BYTE)
)

Insert into TEST_CASE
   (EMP_ID, EMP_TYPE, START_DATE, END_DATE, TOT_SAL)
 Values
   ('111', 'MANAGER', TO_DATE('01/10/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('04/10/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    '150000');

Insert into TEST_CASE
   (EMP_ID, EMP_TYPE, START_DATE, END_DATE, TOT_SAL)
 Values
   ('222', 'MANAGER', TO_DATE('02/01/2005 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('09/30/2007 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    '200000');

Insert into TEST_CASE
   (EMP_ID, EMP_TYPE, START_DATE, END_DATE, TOT_SAL)
 Values
   ('333', 'CONTRACTOR', TO_DATE('12/15/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/15/2007 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    '2500000');

COMMIT;



CREATE TABLE TEST_CASE_EXPLORE(
 EMP_ID      NUMBER,
 EMP_TYPE    VARCHAR2(255 BYTE),
 MONTH_NO    NUMBER,
 MONT_SAL    VARCHAR2(15 BYTES),
 MONT_NAME   VARCHAR2(50 BYTES)
)

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 10, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'OCTOBER');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 11, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'NOVEMBER');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 12, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'DECEMBER');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 1, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'JANUARY');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 2, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'FEBRUARY');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 3, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'MARCH');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 4, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'APRIL');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 5, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'MAY');


INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 6, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'JUNE');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 7, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'JULY');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER',8, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)), 'AUGUST');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(111,'MANAGER', 9, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)), 'SEPTEMBER');


INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 2, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'FEBRUARY');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 3, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'MARCH');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 4, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'APRIL');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 5, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'MAY');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 6, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'JUNE');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 7, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'JULY');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 8, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'AUGUST');

INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 9, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'SEPTEMBER');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 10, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'OCTOBER');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER',11, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'NOVEMBER');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 12, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'DECEMBER');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'MANAGER', 1, (150000(TOT_SAL)/ADD_MONTHS(START_DATE,12)),'JANUARY');



INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'CONTRACTOR', 12, (2500000(TOT_SAL)/(END_DATE-START_DATE)),'DECEMBER');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'CONTRACTOR', 1, (2500000(TOT_SAL)/(END_DATE-START_DATE)),'JANUARY');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'CONTRACTOR', 2, (2500000(TOT_SAL)/(END_DATE-START_DATE)),'FEBRUARY');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'CONTRACTOR', 3, (2500000(TOT_SAL)/(END_DATE-START_DATE)),'MARCH');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'CONTRACTOR', 4, (2500000(TOT_SAL)/(END_DATE-START_DATE)),'APRIL');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'CONTRACTOR', 5, (2500000(TOT_SAL)/(END_DATE-START_DATE)),'MAY');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'CONTRACTOR', 6, (2500000(TOT_SAL)/(END_DATE-START_DATE)),'JUNE');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'CONTRACTOR', 7, (2500000(TOT_SAL)/(END_DATE-START_DATE)),'JULY');
INSERT INTO TEST_CASE_EXPLORE (EMP_ID,EMP_TYPE,MONTH_NO,MONT_SAL,MONT_NAME)
	VALUES
		(222,'CONTRACTOR', 8, (2500000(TOT_SAL)/(END_DATE-START_DATE)),'AUGUST');





		TEST_CASE								TEST_CASE_EXPLORE			
EMP_ID	EMP_TYPE	STRART_DATE	END_DATE	TOTAL_SAL		EMP_ID	EMP_TYPE	MONTH	MOTHLY_SAL
111	MANAGER		1-Mar-08			100000			111	MANAGER		3	8333.333333
222	MANAGER		10-Feb-06	31-Jan-08	150000			111	MANAGER		4	8333.333333
333	CONTRACTOR	15-Apr-07	31-Aug-08	2500000			111	MANAGER		5	8333.333333
444	CONTRACTOR	1-Jul-06			2000000			111	MANAGER		6	8333.333333
										111	MANAGER		7	8333.333333
										111	MANAGER		8	8333.333333
										111	MANAGER		9	8333.333333
										111	MANAGER		10	8333.333333
										111	MANAGER		11	8333.333333
										111	MANAGER		12	8333.333333
										111	MANAGER		1	8333.333333
										111	MANAGER		2	8333.333333
										333	CONTRCTOR	4	277777.7778
										333	CONTRCTOR	5	277777.7778
										333	CONTRCTOR	6	277777.7778
										333	CONTRCTOR	7	277777.7778
										333	CONTRCTOR	8	277777.7778
										333	CONTRCTOR	9	277777.7778
										333	CONTRCTOR	10	277777.7778
										333	CONTRCTOR	11	277777.7778
										333	CONTRCTOR	12	277777.7778