Re: Representing NULL-Vallues

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 5 Sep 1999 05:31:33 GMT
Message-ID: <7qsv7l$bgj$1@news.seed.net.tw>

Sebastian Hein <heinseb_at_ruf.uni-freiburg.de> wrote in message news: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?

It looks OK. It works in SQL*Plus.
What does you mean "not work"? Received on Sun Sep 05 1999 - 00:31:33 CDT