title: creating table but return "too many value" error
body: <p>I am creating a table by using the following code, I don't have too many columns but still getting errors</p>
  
  <pre><code>Create table corrYear as
  Select  a.Symbol ASymbol,b.Symbol BSymbol, corr(a.logp,b.logp) Correlation
  From logprofitDEC a join logprofitDEC b
  on a.Tdate=b.Tdate
  where a.Symbol&gt;b.symbol
  And  a.symbol in (select asymbol,bsymbol from pairDec1st2nd)
  And  b.symbol in (select asymbol,bsymbol from pairDec1st2nd)
  And To_date(a.Tdate,'YYYYMMDD') between  DATE'2013-01-01' AND DATE'2013-12-31' 
  And To_date(a.Tdate,'YYYYMMDD') between  DATE'2013-01-01' AND DATE'2013-12-31' 
  group by a.symbol,b.Symbol;
  </code></pre>
  
  <p>The error is </p>
  
  <pre><code>00913.00000-"too many values"
  </code></pre>
  
  <p>I don't know why, usually this is caused by too many columns. What to do please?</p>