alter session set nls_language='english';
alter session set nls_date_format='DD-MON-YYYY';

create table sales_denorm
(sale_id number(8),
 customer_id varchar2(10),
 sale_date date,
 product1 varchar2(10), amount1 number(2), price1 number(5,2),
 product2 varchar2(10), amount2 number(2), price2 number(5,2),
 product3 varchar2(10), amount3 number(2), price3 number(5,2),
 product4 varchar2(10), amount4 number(2), price4 number(5,2)
 );

create sequence seq_sales start with 1 increment by 1;

declare
  i number:=1;
begin
  for i in 1..100 loop
    insert into sales_denorm values (seq_sales.nextval, 'BB00000'||to_char(i), '13-MAR-2003',
      'SP1011', 10, 10, 'SP1063', 1, 210, 'SP1001', 2, 25, 'SP1012', 1, 34);
    insert into sales_denorm values (seq_sales.nextval, 'BB00000'||to_char(i), '25-JUN-2003',
      'SP1065', 1, 10, 'SP1220', 11, 32, 'SP1213', 2, 15, 'SP1064', 2, 20);
  end loop;
  commit;
end;
/
