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

<mooxe_at_hotmail.com> wrote in message
news:Yb9rc.2770$_V4.609_at_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
>
>

You can create a view or use the sql:

select opwin, oplost, (opwin+oplost) gamesplayed from gametable;

Unless you built the table with the " around the field names you don't need them.

Jim Received on Fri May 21 2004 - 02:25:43 CEST