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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle NULL vs '' revisited

Re: Oracle NULL vs '' revisited

From: Matthew Harrison <m.harrisson_at_craznar.com>
Date: Sat, 18 Aug 2007 12:01:42 +1000
Message-ID: <13cckp4ki8fav76@corp.supernews.com>


hpuxrac wrote:
> Why don't you define it as NOT NULL and remove the "is conceptually"
> out of the equation.

I need to define it as NOT NULL, however '' is a valid value (and has a critical meaning) for the value.

SO - it is a NOT NULL value which has to store '' as a possible value.

-- 
Pinging self [127.0.0.1] with 32 bites of banana cake:

Ping statistics for 127.0.0.1:
     Slices: Sent = 4, Received = 0, Lost = 4 (100% loss),
Received on Fri Aug 17 2007 - 21:01:42 CDT

Original text of this message

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