Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using the Replace function

655717Nov 18 2008 — edited Nov 19 2008
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
This post has been answered by Frank Kulash on Nov 19 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2008
Added on Nov 18 2008
10 comments
378 views