Re: CHR(0) ver null

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: srinivasanram2004@xxxxxxxxx
  • Date: Wed, 8 Aug 2007 09:47:18 -0700

OK, this is hilarious.

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


On 8/7/07, Ram Srinivasan <srinivasanram2004@xxxxxxxxx> 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@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.




-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: