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 -> Oracle NULL vs '' revisited

Oracle NULL vs '' revisited

From: Matthew Harrison <m.harrisson_at_craznar.com>
Date: Sat, 18 Aug 2007 00:49:49 +1000
Message-ID: <13cbdd8o2ffin37@corp.supernews.com>


Ok, I'm developing another oracle application where the distinction between NULL and '' will be important.

Given Oracle doesn't adhere to SQL standards for the distinction, is there any best practices for comparing, and storing blank strings in a table where the field is conceptually NOT NULL.

Thank you.

-- 
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 - 09:49:49 CDT

Original text of this message

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