Re: CHR(0) ver null

From: Ram Srinivasan <srinivasanram2004_at_gmail.com>
Date: Tue, 7 Aug 2007 14:18:47 -0400
Message-ID: <9fc1ae810708071118k3f3fbbcbi605f3db4dd8aae6f@mail.gmail.com>

Hi Guys:

  Null <> CHR(0).
  In fact NULL is totally imbecile. Here is a poem I wrote long time ago.

---

Ode to Null

It is neither a mountain nor a creek;

It is neither Latin nor Greek;

It is neither strong nor weak;

It is neither courageous nor meek.

It is neither nothing nor something;

It is neither a good thing nor a bad thing;

It is neither a big thing nor a small thing;

But it is something we have to deal with among all things.

It is neither a lender nor a borrower;

It is neither a zero nor a blank;

It is neither here nor there;

But, in programming, it is everywhere.

Oh! NULL, Oh! NULL!

You are neither a push nor a pull;

You always make us mull

Ov'r your dangerous effects, Oh! NULL!

Ram Srinivasan

21-Feb-2000

---

On 8/2/07, Thomas Day <tomdaytwo_at_gmail.com> wrote:
>
> This works perfectly fine for me in 10.2
>
> select OWNER, TABLE_NAME from dba_TABLES where owner >= CHR(0)
> AND TABLE_NAME >= CHR(0)
> ORDER BY 1,2
>
> On the other hand "null" is undefined. It's not CHR(0).
>
>
> On 8/2/07, Wojciech Skrzynecki <wojciech.skrzynecki_at_gmail.com> wrote:
> >
> > Hello
> >
> > What component in DB I have to install to use ">= CHR(0)" instead of
> > "is not null" .
> >
> >
> >
> > --
> > Wojciech Skrzynecki
> > Database Administrator
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>

-- 
Sincerely
Ram Srinivasan
Charlottesville, VA.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 07 2007 - 13:18:47 CDT