Floating issue

nani0907 · Post by **nani0907** » Tue Dec 02, 2008 7:46 am

Hi all

i am getting the below error from the oracle query used.

floating point decimal is not fully supported; adjusting the scale.

Ora query used.
SELECT
DECODE(FN.column A,NULL,'NULL',FN.column A) AS column A,
SUM(CAST(FN.column B AS DECIMAL(38,10))) AS column B
FROM
Table FN
WHERE
FN.DATE=to_date(20071231,'yyyymmdd')
GROUP BY
column A

In oraclestage,mentioned column as decimal 38,10.

Please help me for the above issue.

Aslo unable to view premium content.

chulett · Post by **chulett** » Tue Dec 02, 2008 8:11 am

nani0907 wrote:Also unable to view premium content.

I really don't understand why people feel the need to mention this. It is obvious who is a Premium member and who isn't, that's clearly marked on every post. All this statement says is you don't want any of the Premium posters to help you. So be it.

nani0907 · Post by **nani0907** » Tue Dec 02, 2008 8:34 am

I donot mean that.
sorry for mentioning it.

chulett · Post by **chulett** » Tue Dec 02, 2008 8:38 am

What is the definition of "Column B" in the Oracle table? Why do you feel the need to CAST the column during the select?

nani0907 · Post by **nani0907** » Tue Dec 02, 2008 8:46 am

Hi,

The column B is mentioned as Number datatype in oracle table without length.

chulett · Post by **chulett** » Tue Dec 02, 2008 8:52 am

Figured as much. What about the second question?

nani0907 · Post by **nani0907** » Tue Dec 02, 2008 9:01 am

I have imported the meta data from the Orch schema definitions which shows as decimal 38, 10 . hence used the cast function to do the same.

Mike · Post by **Mike** » Tue Dec 02, 2008 9:10 am

Not sure if it will matter, but...

How about CASTing the SUM instead of SUMing the CAST?

Mike

nani0907 · Post by **nani0907** » Tue Dec 02, 2008 11:21 pm

I have casted the sum and the issue is resoved.

Thanks mike

DSXchange

Floating issue

Floating issue

Re: Floating issue