Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Looking for some help on a simple command....

Looking for some help on a simple command....

From: <mooxe_at_hotmail.com>
Date: Thu, 20 May 2004 17:14:13 -0700
Message-ID: <Yb9rc.2770$_V4.609@read1.cgocable.net> 





(Im a newbie at oracle)




I have a field in my database called "gamesplayed" and I would like that to
display the total of 'opwin' & 'oplost' automatically. Sort of like adding a
formula to a field in excel, but I cant figure out how to do this or if its
even possible.



example:



'opwin' 9

'oplost' 19

'gamesplayed' 28 (i would like this field to update automatically)





I am thinking I just add the command "select sum(opwin+oplost) from
gametable;" to 'gamesplayed', but how?




Andrew
Received on Thu May 20 2004 - 19:14:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US