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.
NVL Function support for parallel Oracle Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 80
- Joined: Sat Mar 18, 2006 10:27 pm
Could you post your SQL, please?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
.. And let us know, what you mean by "not working". Does it throw an error? Or does it give you some unexpected output?
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>