<font face="Verdana">Ooops my bad ... i think this is the same in 9i as well. I seem to recall using NVL(field, '¬') or some other arbitary value just to get it to work previously as well.
And of course, not to mention, the inevitable right padding of spaces in your varchar fields that means that 'Bob' and 'Bob ' never match unless you RTRIM every field that you compare.
</font>
Frodo
@Frodo
Best posts made by Frodo
Latest posts made by Frodo
-
RE: Oracle and NULL
-
RE: Oracle and NULL
<font face="Verdana">Well you can always use NVL...
</font><font style="background-color: rgb(239, 239, 239);">SELECT * FROM SM_STPD_TB
WHERE NVL(SM_STPD_CD, '') != 'XYZ'
</font><font style="background-color: rgb(239, 239, 239);">
</font><font face="Verdana">Or even better, the remarkably obtuse DECODE statement...
</font><font style="background-color: rgb(239, 239, 239);">SELECT * FROM SM_STPD_TB
WHERE DECODE(SM_STPD_CD, NULL, 'ZYX', SM_STPD_CD) != 'XYZ'
</font><font face="Verdana">There's nothing more likely to generate a WTF than multiple embedded decode statements!</font> -
RE: What's Out of Place
It still beggars belief that people still persist in using Toad when there is a superior product that offers all of the features and more (including an awesome debugger) for the measly sum of $150.
Unfortunately at that price they can't afford any sound effects ... instead relying on implementing useful functionality.
Check out http://www.allroundautomations.com/plsqldev.html and discover there is a world beyond SQL+!