Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

String concatenation and conversion to number

610101Jun 4 2008 — edited Jun 4 2008
I had two strings in SOI_QTY column and SOI_QTY_LS column. How can i concatenate the two columns data. Also i want to convert the result to number format.

I had the below code

TO_NUMBER(SOI_QTY||'.'||SOI_QTY_LS) - (SOI_INVI_QTY_BU/IU_CONV_FACTOR/IU_MAX_LOOSE_1) PNDG_QTY

But this statement gives error like invalid number when is use it in some sql queries. Is there is any option for the above statement ?

Also i want to sum the result of the statement given above..

Yogesh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2008
Added on Jun 4 2008
3 comments
1,181 views