ALTER TABLE costs
   ADD PARTITION costs_q1_2002 
   values less than (TO_DATE('01-APR-2002', 'DD-MON-YYYY'));

ALTER TABLE costs 
   ADD PARTITION costs_q2_2002 
   values less than (TO_DATE('01-JUL-2002', 'DD-MON-YYYY'));