title: sql query to return values of dated18 months from now in a single row
body: <p>I have a table with 12 periods(months) as described bellow:</p>
  
  <pre><code>CREATE TABLE  "FORECAST_DATA" (
     "COMPANY_CODE" NUMBER(6,0), 
     "CAT" VARCHAR2(30), 
     "PRODUCT_CODE" VARCHAR2(30), 
     "CUSTOMER_CODE" VARCHAR2(30), 
     "CYEAR" VARCHAR2(30), 
     "CHANNEL" VARCHAR2(30), 
     "P_1" NUMBER(6,0), 
     "P_2" NUMBER(6,0), 
     "P_3" NUMBER(6,0), 
     "P_4" NUMBER(6,0), 
     "P_5" NUMBER(6,0), 
     "P_6" NUMBER(6,0), 
     "P_7" NUMBER(6,0), 
     "P_8" NUMBER(6,0), 
     "P_9" NUMBER(6,0), 
     "P_10" NUMBER(6,0), 
     "P_11" NUMBER(6,0), 
     "P_12" NUMBER(6,0), 
     "FORECAST_COST" NUMBER(6,0)
     )
  </code></pre>
  
  <p>This table is used for forecasting, assuming the current date is Feb 2013, I want to write a query that returns 18 periods( P_2 to P_12 in 2013 plus P_1 to  P_7 in 2014) in a single row.</p>
  
  <p>Thank you, </p>
  
  <p>Sabe</p>