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: mountain man <hobbit_at_southern_seaweed.com.op>
Date: Thu, 01 Dec 2005 00:52:50 GMT
Message-ID: <CPrjf.7970$ea6.3050@news-server.bigpond.net.au>


"Hugo Kornelis" <hugo_at_pe_NO_rFact.in_SPAM_fo> wrote in message news:9j4so1h49jelr1rlfmcc48h89ta9ro2f6j_at_4ax.com...

> Please tell me what dictionary you checked. Here are some quotes from
> dictionaires I checked:

In practice the dictionaries you need to check are the internal SQL Syntactical Help Files (and associated documentation) in respect of Ms SQL Server, Oracles' Oracle, IBM's DB2 and then any other (R)DBMS providers which are outside of the above 3 market share.

 In theory, you could check the SQL standards committee reports and their history, but the theory side is totally endless and in-the-end must bow to current practice as established in the market place, and as reflected in the distribution and use of the (relational) database management system software in which the NULL is to be (INTERNALLY) defined.

Otherwise its like seeking a standard specification for a car component (eg: the differential) for a car that does not exist on the planet. Its all very well to be theoretical, but theory and practice are (imo) oscillatory wrt their dominance at any one time. At the moment practice has raced ahead and theory is lagging 30 years behind it.

Have a good weekend when it arrives.

Pete Brown
http://www.mountainman.com.au/essenes/ Received on Wed Nov 30 2005 - 18:52:50 CST

Original text of this message

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