Re: CHR(0) ver null
- From: "Ram Srinivasan" <srinivasanram2004@xxxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>
- Date: Wed, 8 Aug 2007 17:35:18 -0400
Jared:
The company I used to work for in 2000, still uses this poem in their
training classes.
Thanks for your comments. It is indeed hilarious. And all of it is true.
Ram Srinivasan
-------------------------
On 8/8/07, Jared Still <jkstill@xxxxxxxxx> wrote:
>
> 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
>
--
Sincerely
Ram Srinivasan
Charlottesville, VA.
Other related posts:
