title: ORA-00933: SQL command not properly ended while using pivot
body: <p>when i am using the following query i get ORA-00933 error</p>
  
  <pre><code>SELECT * FROM sales PIVOT (sum(quantity) FOR color IN ('WHITE','DARK'));
  </code></pre>
  
  <p>Here my table description is as follows:</p>
  
  <pre><code>CREATE TABLE SALES(
  ITEM_NAME CHAR(20) NOT NULL,
  COLOR CHAR(20) NOT NULL,
  CLOTHES_SIZE CHAR(10) NOT NULL,
  QUANTITY INTEGER NOT NULL
  );
  </code></pre>
  
  <p>and the test data is:</p>
  
  <pre><code>SKIRT DARK SMALL 2
  SKIRT DARK MEDIUM 5
  SKIRT DARK LARGE 1
  SKIRT PASTEL SMALL 11
  SKIRT PASTEL MEDIUM 9
  SKIRT PASTEL LARGE 15
  SKIRT WHITE SMALL 2
  SKIRT WHITE MEDIUM 5
  SKIRT WHITE LARGE 3
  DRESS DARK SMALL 2
  DRESS DARK MEDIUM 6
  DRESS DARK LARGE 12
  DRESS PASTEL SMALL 4
  DRESS PASTEL MEDIUM 3
  DRESS PASTEL LARGE 3
  DRESS WHITE SMALL 2
  DRESS WHITE MEDIUM 3
  DRESS WHITE LARGE 0
  SHIRTS DARK SMALL 2
  SHIRTS DARK MEDIUM 6
  SHIRTS DARK LARGE 6
  SHIRTS PASTEL SMALL 4
  SHIRTS PASTEL MEDIUM 1
  SHIRTS PASTEL LARGE 2
  SHIRTS WHITE SMALL 17
  SHIRTS WHITE MEDIUM 1 
  SHIRTS WHITE LARGE 10
  PANTS DARK SMALL 14
  PANTS DARK MEDIUM 6
  PANTS DARK LARGE 0
  PANTS PASTEL SMALL 1
  PANTS PASTEL MEDIUM 0
  PANTS PASTEL LARGE 1
  PANTS WHITE SMALL 3
  PANTS WHITE MEDIUM 0
  PANTS WHITE LARGE 2
  </code></pre>