running total (SQL query)

From: Bruno Cirone <bruno_at_bc3.GUN.de>
Date: Tue, 12 Jan 1993 18:39:53 GMT
Message-ID: <C0r7uI.po_at_bc3.GUN.de>


I have this table:

        Name Score

	Werner		200
	Hugo	       -100
	Heinz		300
	Bruno		100

I want this table to be printed like the following:

        Name Score total

	Werner		200	200
	Hugo	       -100	100
	Heinz		300	400
	Bruno		100	500

How can I do that with Oracle (without report-generator) ?

-- 
Bruno Cirone 			InterNet: <bruno_at_bc3.gun.de>
Theodor-Heuss-Ring 19-21	UUCP: ...!unido!easix!flyer!bc3!bruno
5000 Koeln (Cologne) 1		Fax : +49-221-7710931
FRG / Germany			Tel.: +49-221-7710929
Received on Tue Jan 12 1993 - 19:39:53 CET

Original text of this message