CREATE TABLE sales (partycode VARCHAR2(10), sale_date DATE, target NUMBER(10,2), sale NUMBER(10,2));

INSERT INTO sales values ('0001', TO_DATE('01-01-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('02-02-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('05-03-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('01-04-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('01-05-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('01-06-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('01-07-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('05-09-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('05-11-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('01-01-2009','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('05-02-2009','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('09-05-2009','DD-MM-YYYY'), 0, 0);
commit;

SELECT
       partycode                      PARTYCODE,
       to_char(sale_date,'YYYY')      Year,
       to_char(sale_date,'MM-MONTH')  Momth,
       target                         TARGET,
       sale                           sale
  FROM  sales 
  ORDER BY 1,2;