Re: Representing NULL-Vallues

From: Paul Q <paulq_at_home.com>
Date: Sat, 04 Sep 1999 17:01:45 GMT
Message-ID: <ZfcA3.3017$kL1.62646@news2.rdc1.on.home.com>

you have to do a nvl on all columns that may possibly be null.

ie select nvl(var1,'.'),nvl(var2,'.') FROM table1

Sebastian Hein wrote in message <37D12EF0.B3C578A0_at_ruf.uni-freiburg.de>...
>Hello,
>I want to extract values out of an ORACLE-database. Some of the values
>are NULL-values which I want represent in the output-file by '.' (dot) .
>I can't find the way how to do it:
>
>SET NULL "."
>SPOOL out.dat
>SELECT var1, var2, var3 FROM table1 ...
>
>doesn't work. Is anybody out there knowing how to deal with this
>problem?
>
>SH
>
>
>
Received on Sat Sep 04 1999 - 12:01:45 CDT