I want to generate newspaper bill according to the following criteria.

In a newspaper publisher, the cost of newspaper on Tuesday and Thursday is Rs.3/- and on other days it is Rs.2/-. So my requirement is to generate billing of newspaper as per the choice of user input at runtime using Oracle Pl/SQL programming.

NOTE:

The billing can be as Daily/Weekly/Monthly/Yearly/Any specific duration based on the requirement.(For Ex. i want billing from August 2015 to March 2016)
Oracle Scheduler, Stored Procedures/Functions, Cursor, Loops can be used.

Any help will be appreciated.

Thank You

create table prices (
  price_date date primary key
    check (price_date = trunc(price_date)),
  unit_cost  number
);

select sum(unit_cost) from prices
where  price_date between date'2016-01-01' and date'2016-01-31';

update prices 
set    unit_cost = 4
where  price_date = date'2016-07-01';