Oracle NULL vs '' revisited - comp.databases.oracle.server

Bericht van Oracle NULL vs '' revisited-discussie

Matthew Harrison

Profiel weergeven

Meer opties 17 aug 2007, 16:49

Nieuwsgroepen: comp.databases.oracle.server

Van: Matthew Harrison <m.harris...@craznar.com>

Datum: Sat, 18 Aug 2007 00:49:49 +1000

Lokaal: vr 17 aug 2007 16:49

Onderwerp: Oracle NULL vs '' revisited

  Doorsturen | Afdrukken | Discussielijn weergeven
  | Origineel weergeven
  | Dit bericht rapporteren | Berichten van deze auteur zoeken
  

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),

Doorsturen