NVL Function support for parallel Oracle Stage

venkatvelpula · Post by **venkatvelpula** » Mon Jun 16, 2008 9:54 am

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.

ArndW · Post by **ArndW** » Mon Jun 16, 2008 10:04 am

Could you post your SQL, please?

Minhajuddin · Post by **Minhajuddin** » Mon Jun 16, 2008 11:28 am

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

iDomz · Post by **iDomz** » Tue Jun 17, 2008 2:41 am

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