Oracle NULL vs '' revisited

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

Relevant Pages

  • Re: Comparisons of TCA between Oracle and SQL Server
    ... by SQL Server is equivalent to the term "schema" in Oracle. ... however the distinction is irrelevant as ... most database developers don't know the difference and set up one ... Sybrand Bakker, Senior Oracle DBA ...
    (comp.databases.oracle.server)
  • Re: Remove default value from table definition
    ... I'm not that this is a distinction with a difference, but the OP seems to think it is. ... is on all Oracle tables all the time. ... Daniel A. Morgan http://www.psoug.org damorgan@xxxxxxxxxxxxxxxx. ...
    (comp.databases.oracle.server)
  • Re: Oracle NULL vs revisited
    ... is different to Oracle, Oracle gets called "non-standard". ... The basis for saying that "Oracle doesn't adhere to SQL standards" is the ... "A character string is a sequence of characters. ...
    (comp.databases.oracle.server)
  • Re: Fetch 6 records from a table randomly
    ... implement SQL standards in a non standard way. ... and have the ruby random number generator insert a random value. ... The rownum column in oracle exists only in a result set so it will work ...
    (comp.lang.ruby)
  • Re: Oracle NULL vs revisited
    ... is different to Oracle, Oracle gets called "non-standard". ... The basis for saying that "Oracle doesn't adhere to SQL standards" is the ... "A character string is a sequence of characters. ...
    (comp.databases.oracle.server)