Home » SQL & PL/SQL » SQL & PL/SQL » How to sum the fields in the oracle?????
How to sum the fields in the oracle????? [message #18830] Sun, 17 February 2002 19:30 Go to next message
Pravina
Messages: 1
Registered: February 2002
Junior Member
hi!!!!! there,

I would like to sum the fields and store the o/p in the new field.

Please note that i do not want to sum records, i know it...... i want to sum more than one fields.

Thanks for your time.

Pravina

Report message to a moderator

Re: How to sum the fields in the oracle????? [message #18835 is a reply to message #18830] Mon, 18 February 2002 01:38 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
can u explain little bit more with an example

Report message to a moderator

Re: How to sum the fields in the oracle????? [message #18842 is a reply to message #18830] Mon, 18 February 2002 08:50 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
update tab1 set new_field=field1+field2;

Report message to a moderator

Previous Topic: Stored Procedure Tuning.
Next Topic: SQL select using Date comparisons
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Aug 21 06:56:55 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.