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: So what's null then if it's not nothing?

Re: So what's null then if it's not nothing?

From: Hugo Kornelis <hugo_at_pe_NO_rFact.in_SPAM_fo>
Date: Thu, 24 Nov 2005 23:44:54 +0100
Message-ID: <4agco1hep795rmle3utnegjvqpr9ci1hf7@4ax.com>


On Thu, 24 Nov 2005 12:28:46 GMT, FrankHamersley wrote:

(snip)
>Where it gets more interesting is if you throw the following at the RM
>(Pick will have no trouble AFAICT).
>
><People><Person><Name>Hugo Kornelis</Name></Person>
><Person><Name>Frank
>Hamersley</Name><Birthday>19980706</Birthday></Person></People>

Hi Frank,

In RM, the debate is still going on the "correct" way to represent this.

In SQL's interpretation of RM, the solution is simple:

CREATE TABLE People (Name CHARACTER VARYING (100) NOT NULL,

                     Birthday DATE,
                     PRIMARY KEY (Name)
                    )

INSERT INTO People (Name, Birthday)
VALUES ('Hugo Kornelis', NULL)
INSERT INTO People (Name, Birthday)
VALUES ('Frank Hamersley', '19980706')

BTW, aren't you a bit young for the explicit content of this group? :-)

Best, Hugo

-- 

(Remove _NO_ and _SPAM_ to get my e-mail address)
Received on Thu Nov 24 2005 - 16:44:54 CST

Original text of this message

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