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