往DUAL表中增加行信息(dual是一个虚拟表)

  
  

   
   SELECT 
   
   TO_CHAR
   
   (
   
   TO_DATE
   
   (
   
   '2014-12-05'
   
   , 
   
   'yyyy-mm-dd'
   
   ) 
   
   + 
   
   ROWNUM 
   
   - 
   
   1
   
   , 
   
   'yyyy-mm-dd'
   
   ) 
   
   DAY
  
  
  
  
  
   
   FROM 
   
   DUAL 
   
   A
  
  
  
  

   
   CONNECT 
   
   BY 
   
   ROWNUM 
   
   <= 
   
   TO_DATE
   
   (
   
   '2014-12-11'
   
   , 
   
   'yyyy-mm-dd'
   
   ) 
   
   - 
   
   TO_DATE
   
   (
   
   '2014-12-05'
   
   , 
   
   'yyyy-mm-dd'
   
   ) 
   
   + 
   
   1
   
   ;