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.