Re: the difference between NULL and ' ':an interseting result
Date: 4 Jan 1994 16:28:49 GMT
Message-ID: <2gc5g1$2gr_at_jac.zko.dec.com>
In article <CJ3MsD.CyI_at_uk.ac.brookes>, p0070621_at_oxford-brookes.ac.uk (Tommy Wareing) writes:
|>Path: jac.zko.dec.com!pa.dec.com!decwrl!uunet!cs.utexas.edu!not-for-mail
|>From: p0070621_at_oxford-brookes.ac.uk (Tommy Wareing)
|>Newsgroups: comp.databases.oracle
|>Subject: Re: the difference between NULL and ' ':an interseting result
|>Date: 4 Jan 1994 03:41:16 -0600
|>Organization: Oxford Brookes University
|>Lines: 38
|>Sender: daemon_at_cs.utexas.edu
|>Message-ID: <CJ3MsD.CyI_at_uk.ac.brookes>
|>References: <1JAN199414124622_at_zeus.tamu.edu> <2g9akt$3v6_at_jac.zko.dec.com>
|>NNTP-Posting-Host: cs.utexas.edu
|>
|>My apologies for jumping in feet first: I've missed some of this thread.
|>
|>feenan_at_nova.enet.dec.com wrote:
|>> The following scenario does not show the difference between NULL and
|>> ' '. The problem is that (as shown by this thread) many
|>> applications/users don't like NULL. When unloading data into a flat
|>> file representation most database managers recognize this and have a
|>> method of representing NULL with some value (usually blank for text
|>> and 0 for numeric). Anyways try the following using this mechanism in
|>> Oracle and see what happens...I think it is SET NULL in Oracle. The
|>> default value for this I bet is a blank...thus the difference between
|>> the two files is by default the, none.
|>
|>The above is true, but the default display value of null is an empty
|>string. The problem with
|> SELECT NULL FROM DUAL
|>vs
|> SELECT ' ' FROM DUAL
|>
Received on Tue Jan 04 1994 - 17:28:49 CET