-- Create table to store sales data

CREATE TABLE fact_sales_summary
(month_id            NUMBER(6),
  sales_amount      NUMBER
);

-- Create Previous year sales data

INSERT INTO fact_sales_summary
(month_id, sales_amount)
SELECT
   TO_CHAR(sysdate,'yyyy')-1||LPAD(level,2,'0'),
   ROUND(100000*DBMS_RANDOM.value)
FROM DUAL
  CONNECT BY level <= 12;
COMMIT;

-- Create Current year sales data

INSERT INTO fact_sales_summary
(month_id, sales_amount)
SELECT
   TO_CHAR(sysdate,'yyyy')||LPAD(level,2,'0'),
   ROUND(100000*DBMS_RANDOM.value)
FROM DUAL
  CONNECT BY level <= TO_CHAR(sysdate,'mm');
COMMIT;

---