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
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
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;
Previous Topic: Stored Procedure Tuning.
Next Topic: SQL select using Date comparisons
Goto Forum:
  


Current Time: Fri Mar 29 08:17:03 CDT 2024