title: display number of visits per month this year
body: <p>I want to display total number of visits per month this year . But the following query returns error code of missing expression. What have i missed? </p>
  
  <pre><code> SELECT CASE 
       WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '),     'mm/dd/yyyy')  = 1 THEN 'January '
       WHEN extract(month from date  TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '),   'mm/dd/yyyy')  = 2 THEN 'February'
  WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 3 THEN 'March'
  WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 4 THEN 'April'
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 5 THEN 'May'
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 6 THEN 'June'
  WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 7 THEN 'July'
  WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 8 THEN 'August'
  WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 9 THEN 'September'
  WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 10 THEN 'October'   
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 11 THEN 'November'   
   ELSE 'December'
      END AS "Month " , 
      COUNT(*) AS "Number of visits"
   FROM allrecord where  extract(year from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')= extract(year from date sysdate) 
   GROUP BY CASE 
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 1 THEN 'January '
       WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 2 THEN 'February'
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 3 THEN 'March'
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 4 THEN 'April'
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 5 THEN 'May'
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 6 THEN 'June'
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 7 THEN 'July'
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 8 THEN 'August'
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 9 THEN 'September'
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 10 THEN 'October'   
   WHEN extract(month from date TO_DATE (TO_CHAR (visit_time, 'mm/dd/yyyy '), 'mm/dd/yyyy')  = 11 THEN 'November'   
  
         ELSE 'December'
            END;
  </code></pre>
  
  <p>An extra question to ask , I am creating a application using ORacle application builder . But after I created a page and want to edit the records in the form , an error message shows that data can be be fetched . What does it mean? Any steps I missed?</p>