home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 863 of 2,288   
   Ken Denny to nullpointer   
   Re: how to use plsql to calculate compon   
   29 Dec 03 14:23:39   
   
   From: ken@kendenny.com   
      
   null_pointer@rediffmail.com (nullpointer) wrote in   
   news:c0728f9d.0312282347.59b6f551@posting.google.com:   
      
   > PL SQL autobinds so no need to specify those as bind variables   
   > This should work   
   >   
   >    1  declare   
   >    2  money number :=50000.00;   
   >    3  year number :=1;   
   >    4  begin for i in 1..17   
   >    5  loop insert into my_401k values(year, money + 0.1*money);   
   >    6  year := year +1;   
   >    7  end loop;   
   >    8* end;   
   >   
   > Hope it Helps   
   > nullpointer   
      
   That will get around the error message, but it won't give you the results   
   you're looking for. Note: you never changed the value of the variable   
   money, so every year money is going to have 55000.00 in the moey column.   
      
   --   
   Ken Denny   
   http://www.kendenny.com/   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca