RE: CHR(0) ver null

Lex would have liked that a lot, I'm sure.... J  

--

Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak_at_il.proquest.com <mailto:mark.bobak_at_il.proquest.com> www.proquest.com <http://www.proquest.com> www.csa.com <http://www.csa.com>

ProQuest...Start here.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ram Srinivasan Sent: Tuesday, August 07, 2007 2:19 PM
To: tomdaytwo_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: CHR(0) ver null  

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 - 14:26:20 CDT