Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Functions in SQL - very odd problem.

Re: Functions in SQL - very odd problem.

From: SteveS <steve.cat.south_at_cat.blueyonder.co.uk>
Date: Mon, 18 Apr 2005 18:03:59 GMT
Message-ID: <jES8e.14938$G8.5468@text.news.blueyonder.co.uk>

"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message news:d40s2m$es3$2_at_news1.zwoll1.ov.home.nl...
> SteveS wrote:
>> "SteveS" <steve.cat.south_at_cat.blueyonder.co.uk> wrote in message
>> news:jEK8e.14616$G8.6811_at_text.news.blueyonder.co.uk...
>>
>> Apparently this problem has been solved, so pls ignore, thanks.
>>
>> Steve S
>
> As a courtesy to all that read your posting,
> what resolved the problem?
>

You're quite right, sorry. Was snowed under....

Solution was simply to reorganise the query so as to eliminate:

nvl(whatever,'NULL') in ('NULL','*','d')

Steve S   Received on Mon Apr 18 2005 - 13:03:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US