RE: CHR(0) ver null

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <srinivasanram2004@xxxxxxxxx>, <tomdaytwo@xxxxxxxxx>
  • Date: Tue, 7 Aug 2007 15:26:20 -0400

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@xxxxxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxxxxx> 
www.proquest.com <http://www.proquest.com> 
www.csa.com <http://www.csa.com> 

ProQuest...Start here. 

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ram Srinivasan
Sent: Tuesday, August 07, 2007 2:19 PM
To: tomdaytwo@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxx > wrote: 

Hello

What component in DB I have to install to use  ">= CHR(0)" instead of
"is not null" . 



--
Wojciech Skrzynecki
Database Administrator
--
//www.freelists.org/webpage/oracle-l 



 




-- 
Sincerely
Ram Srinivasan
Charlottesville, VA. 

Other related posts: