summing syntax

From: Brock <wade.brock_at_yahoo.com>
Date: Thu, 24 Sep 2009 20:09:16 -0700 (PDT)
Message-ID: <0e3ceda7-aa52-4f45-80e2-f7a3c470e132_at_q14g2000vbi.googlegroups.com>

Thanks in advance for any clues! I'm trying to edit an existing stored procedure in Oracle and need to know how to code using SUM in this scenario:

SELECT TableA.FieldA, //character
TableA.FieldB //number

Pseudocode: If FieldA = 'Virginia' then add that record's FieldB to running total
 then running total = TotalReturns
FROM
WHERE Received on Thu Sep 24 2009 - 22:09:16 CDT