Floating issue
Moderators: chulett, rschirm, roy
Floating issue
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.
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.
thanks n regards
nani
nani
Re: Floating issue
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 wrote:Also unable to view premium content.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers