Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

Some Days I Feel Like I Know Nothing About Oracle More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

NVL() (Score:1)

by runrig (3385)

If you know that the possibly null column can not be some value (say a single space) or you want to assume null is the same as some value, then you can use:

where col1 != NVL(col2, ' ')
- Re:NVL() (Score:2)
  
  by VSarkiss (704) on 2007.08.30 17:32 (#57290) Journal
  
  And if you want to be SQL-92 compliant, you can use COALESCE, which works the same as NVL (but sounds better, even though it takes longer to type).
  
  Reply to This
  
  Parent
  - Re: (Score:1)
    
    by grinder (1100)
    
    What does COALESCE do? (As opposed to NVL).

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.