Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 1489 invoked from network); 8 Aug 2007 12:29:59 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2007 12:29:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1EC5C722BBE; Wed, 8 Aug 2007 13:27:41 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26545-03-2; Wed, 8 Aug 2007 13:27:41 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C2818722C4E; Wed, 8 Aug 2007 13:27:38 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 08 Aug 2007 12:45:03 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6A5E6724439 for ; Wed, 8 Aug 2007 12:45:03 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15680-03-4 for ; Wed, 8 Aug 2007 12:45:03 -0400 (EDT) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.186]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 90B45723CB6 for ; Wed, 8 Aug 2007 12:45:01 -0400 (EDT) Received: by rv-out-0910.google.com with SMTP id c27so187930rvf for ; Wed, 08 Aug 2007 09:47:18 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=cQjPRipe4e7f/tLZOJg0Z//iLyRAjbM+2EbLxdxJ+S++zOxO6uNc5FYlZD6/7UnIbXsUtarsWHwqrNLMZDwBQhvjPI5tGaZUMh2dawdrox6tD4AxKBGv16LartJubfnaymesUp8FAAPa67ISWVH5PIbd10Xc9w4Dm+f5Tg3M4Gk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=oLSuP1nZSDYyzaHJjrVuI05ukK6Nezbupqs/tYLMr8mHwTW+dl/Y71xuYoFXtZKHDxzYLnTIeZcYpVWdnRTkg4ydzmae02IMBXT8imvURrTQbX5DJyicYMq6hRp/1p+SmV+IL2gToPBY0VvmoB+FD2xmjAeUMCY/cDYjN7cwMHY= Received: by 10.140.127.1 with SMTP id z1mr575630rvc.1186591638563; Wed, 08 Aug 2007 09:47:18 -0700 (PDT) Received: by 10.141.53.16 with HTTP; Wed, 8 Aug 2007 09:47:18 -0700 (PDT) Message-ID: Date: Wed, 8 Aug 2007 09:47:18 -0700 From: "Jared Still" To: srinivasanram2004@gmail.com Subject: Re: CHR(0) ver null Cc: tomdaytwo@gmail.com, oracle-l@freelists.org In-Reply-To: <9fc1ae810708071118k3f3fbbcbi605f3db4dd8aae6f@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1245_8758078.1186591638514" References: <9f0e18730708021144p1beb5e95l45951801d7867dfc@mail.gmail.com> <9fc1ae810708071118k3f3fbbcbi605f3db4dd8aae6f@mail.gmail.com> X-archive-position: 424 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-to: jkstill@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_1245_8758078.1186591638514 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline OK, this is hilarious. This needs to have a permanent spot somewhere on the web. On 8/7/07, Ram Srinivasan wrote: > > 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 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 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. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist ------=_Part_1245_8758078.1186591638514 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline OK, this is hilarious.

This needs to have a permanent spot somewhere on the web.


On 8/7/07, Ram Srinivasan < srinivasanram2004@gmail.com> wrote:
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@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@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.



--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
------=_Part_1245_8758078.1186591638514-- -- http://www.freelists.org/webpage/oracle-l