--- CSC 365 Spring 2008
--- Lab 8 BAKERY dataset test 02

--- testing purchase()

declare

begin

  bakery.purchase('ARNN','02-NOV-07','Cookie','Lemon');
  bakery.purchase('DUKELOW', '03-NOV-07', 'Tart','Pecan');
  bakery.purchase('DUKELOW', '03-NOV-07', 'Tart','Pecan');
  

end;
/


select * from receipts where SaleDate > to_date('31-OCT-07','DD-MM-YY');

select * from items where ReceiptNumber IN 
       (select RNumber from receipts where SaleDate > to_date('31-OCT-07','DD-MM-YY'));