Using: Oracle 10g
I had a question in regards to how I would use the replace function with the following statement:
Tack(global.stats_bb_pak.BB_BAT_AVG_FMT(z(x.Player_id).Total_BIP,
z(x.Player_id).BIP_1B));
**Helpfull Info**
- Tack = function
- global.stats_bb_pak = package where everytime there is a null it outputs a '-' ; Unfortuantly I cannot edit the package and I do need to use it b/c it does other functions so in turn I'm trying to make a change via the replace function.
- In the actual package global.stats_bb_pak.BB_BAT_AVG_FMT = FUNCTION BB_BAT_AVG_FMT (XAB IN NUMBER, XH IN NUMBER)
RETURN VARCHAR2;
**************
What I'm trying to do is everytime there's a NULL I want a NULL to be output, rather then a '-'.
Any suggestions or hints would be appreciated...thanks in advanced
Edited by: user652714 on Nov 18, 2008 4:09 PM
Edited by: user652714 on Nov 18, 2008 4:09 PM