DSXchange

I am trying to retrieve decimal fields using user defined sql thorugh oracle enterprise stage. I am trying to replace decimal field null values to '0'.

The query working fine without NVl Function but it's not working with NVL.

Let me know the possible solutions.

We have to do it through oracle query only.

Could you post your SQL, please?

.. And let us know, what you mean by "not working". Does it throw an error? Or does it give you some unexpected output?

On version 8, I had to cast the output (as number) while using enterprise stage. Something like
CAST(NVL(YourColumn,0) AS NUMBER(24,7)) as YourColumn
in your query