>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.