Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: c.d.theory glossary - NULL

Re: c.d.theory glossary - NULL

From: Leandro Guimar„es Faria Corsetti Dutra <leandro_at_dutra.fastmail.fm>
Date: Sun, 25 Apr 2004 21:20:42 -0300
Message-ID: <pan.2004.04.26.00.20.42.702517@dutra.fastmail.fm>


Em Sat, 24 Apr 2004 17:39:10 -0400, Laconic2 escreveu:

>> You can do that much better with special values.

>
> Except that special values aren't values.

        They are. Part of the domain and type and all that.

> When a row is inserted, and there are no values supplied for one of the
> columns, one of three things can happen: the insert can fail; the inser
> can proceed, with a default value plugged in for the missing value, or a
> NULL can be placed in the location.

        Only if you pressupose NULLs. If you pressupose special values, it is: * the insert proceed with a default values, irrespective if it is   special or normal;
* the insert fails.

        I should learn better than feeding trolls...

-- 
Leandro Guimar√£es Faria Corsetti Dutra           +55 (11) 5685 2219
Av Sgto Geraldo Santana, 1100 6/71               +55 (11) 5686 9607
04.674-000  S√£o Paulo, SP                                    BRASIL
http://br.geocities.com./lgcdutra/
Received on Sun Apr 25 2004 - 19:20:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US