>>I'm doing a left outer join on two tables. I'd like the NULL's for the
>>unmatched values (for the right-side table) to show up as blank's and 0's
>>rather than NULL's.
>
>Check out the NVL() function: it returns either the current value, or the one
>you specify, if the value is null.
SET NULLDISPLAY only allows you to specify a character string, not blanks/0's....