title: Materialized View
body: <p>I want to create materialized view using a sales table.</p>
  <pre><code>--CREATE TABLE SALES_DATA (
  --  Product varchar2(255) default NULL,
  --  Date1 varchar2(255),
  --  Sale varchar2(50) default NULL,
  --  ID number default NULL
  --);
  </code></pre>
  <p>this my sales table.
  sample data for sales table ,</p>
  <pre><code>INSERT INTO SALES_DATA (Product,Date1,Sale,ID) VALUES ('Premarin','1977',22385,1);
  INSERT INTO SALES_DATA (Product,Date1,Sale,ID) VALUES ('Bystolic','1985',23884,2);
  INSERT INTO SALES_DATA (Product,Date1,Sale,ID) VALUES ('Hydrocodone/APAP','1955',30428,3);
  </code></pre>
  <p>Then I want to create materialized view and get below output ,</p>
  <p><a href="https://i.stack.imgur.com/5shSl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5shSl.png" alt="enter image description here" /></a></p>