Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: CHR(0) ver null
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_at_gmail.com> wrote:
>
> OK, this is hilarious.
>
> This needs to have a permanent spot somewhere on the web.
>
>
> On 8/7/07, Ram Srinivasan < srinivasanram2004_at_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_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.
>
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
-- Sincerely Ram Srinivasan Charlottesville, VA. -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 08 2007 - 16:35:18 CDT