create table sales6
(
   sales_id    number,
   sales_dt    date
)
partition by range (sales_dt)
(
   partition p0701 values less than (to_date('2007-02-01','yyyy-mm-dd')),
   partition p0702 values less than (to_date('2007-03-01','yyyy-mm-dd')),
   partition p0703 values less than (to_date('2007-04-01','yyyy-mm-dd')),
   partition p0704 values less than (to_date('2007-05-01','yyyy-mm-dd')),
   partition p0705 values less than (to_date('2007-07-01','yyyy-mm-dd'))   
);

INSERT INTO sales6 VALUES( 1, TO_DATE('02-06-2007','DD-MM-YYYY'));
INSERT INTO sales6 VALUES( 1, TO_DATE('12-02-2007','DD-MM-YYYY'))
INSERT INTO sales6 VALUES( 1, TO_DATE('11-01-2007','DD-MM-YYYY'))
INSERT INTO sales6 VALUES( 1, TO_DATE('15-05-2007','DD-MM-YYYY'))
INSERT INTO sales6 VALUES( 1, TO_DATE('27-04-2007','DD-MM-YYYY'))

ALTER TABLE SALES6 TRUNCATE PARTITION FOR(DATE '02-03-07')

  1* select DATE '02-03-07' from dual
SQL> /

DATE'02-0
---------
07-MAR-02