OraFAQ Forum: SQL & PL/SQL » How to multiply one column data to another column

Home » SQL & PL/SQL » SQL & PL/SQL » How to multiply one column data to another column (10 G R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to multiply one column data to another column [message #318829]

Thu, 08 May 2008 02:34

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

Report message to a moderator

Re: How to multiply one column data to another column [message #318830 is a reply to message #318829]

Thu, 08 May 2008 02:42

Maaher
Messages: 7065
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

Report message to a moderator

Re: How to multiply one column data to another column [message #318832 is a reply to message #318829]

Thu, 08 May 2008 02:57

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL Reference
Chapter 4 Operators
Section Arithmetic Operators

Regards
Michel

Report message to a moderator

Previous Topic:	bulk collect
Next Topic:	Getting Error : ORA-00911: invalid character

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 10 16:09:36 CDT 2025