(
sale_date date,
name varchar2(30),
sale Number(20),
city varchar2(15))
partition by range ( sale_date )
(
partition jan_wines1997 values less than(to_date('01/01/1997','DD/MM/YYYY')),
partition feb_wines1997 values less than(to_date('01/02/1997','DD/MM/YYYY')),
partition mar_wines1997 values less than(to_date('01/03/1997','DD/MM/YYYY')),
partition apr_wines1997 values less than(to_date('01/04/1997','DD/MM/YYYY')),
partition may_wines1997 values less than(to_date('01/05/1997','DD/MM/YYYY')),
partition june_wines1997 values less than(to_date('01/06/1997','DD/MM/YYYY')),
partition july_wines1997 values less than(to_date('01/07/1997','DD/MM/YYYY'))
);
