Home » SQL & PL/SQL » SQL & PL/SQL » How to multiply one column data to another column (10 G R2)
How to multiply one column data to another column [message #318829] Thu, 08 May 2008 02:34 Go to next message
sunilgond
Messages: 35
Registered: January 2008
Location: INDIA
Member

Hi

I want to multiply the data of one column with data of another column in single sql query.

i dont want procedure or cursor for this

is there any function in oracle to multyply



Regards
Sunil Kumar Gond

Re: How to multiply one column data to another column [message #318830 is a reply to message #318829] Thu, 08 May 2008 02:42 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Are you serious about this question?

The asterisk ("*") is the multiplication operator.

select column_1
     , column_2
     , column_1*column_2 x
from   yourtable


MHE
Re: How to multiply one column data to another column [message #318832 is a reply to message #318829] Thu, 08 May 2008 02:57 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference
Chapter 4 Operators
Section Arithmetic Operators

Regards
Michel
Previous Topic: bulk collect
Next Topic: Getting Error : ORA-00911: invalid character
Goto Forum:
  


Current Time: Mon Dec 05 15:18:33 CST 2016

Total time taken to generate the page: 0.06211 seconds