drop table monthly_wine_sales; Create table monthly_wine_sales ( 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')) ); insert into monthly_wine_sales values('3-jan-1997','Andy',45000,'Nile'); insert into monthly_wine_sales values('3-feb-1997','Andy',40000,'Nile'); insert into monthly_wine_sales values('3-mar-1997','Andy',55000,'Nile'); insert into monthly_wine_sales values('3-apr-1997','Andy',25000,'Nile'); insert into monthly_wine_sales values('3-may-1997','Andy',42000,'Nile'); insert into monthly_wine_sales values('3-june-1997','Andy',41000,'Nile'); insert into monthly_wine_sales values('3-jan-1997','Josh',65000,'Skokie'); insert into monthly_wine_sales values('3-feb-1997','Josh',49000,'Skokie'); insert into monthly_wine_sales values('3-mar-1997','Josh',59000,'Skokie'); insert into monthly_wine_sales values('3-apr-1997','Josh',75000,'Skokie'); insert into monthly_wine_sales values('3-may-1997','Josh',62000,'Skokie'); insert into monthly_wine_sales values('3-june-1997','Josh',71000,'Skokie'); insert into monthly_wine_sales values('3-jan-1997','Nichole',120000,'Chicago'); insert into monthly_wine_sales values('3-feb-1997','Nichole',99000,'Chicago'); insert into monthly_wine_sales values('3-mar-1997','Nichole',135000,'Chicago'); insert into monthly_wine_sales values('3-apr-1997','Nichole',115000,'Chicago'); insert into monthly_wine_sales values('3-may-1997','Nichole',92000,'Chicago'); insert into monthly_wine_sales values('3-june-1997','Nichole',141000,'Chicago');