Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: CHR(0) ver null

Re: CHR(0) ver null

From: Don Seiler <don_at_seiler.us>
Date: Fri, 3 Aug 2007 09:13:27 -0500
Message-ID: <716f7a630708030713t37cdf38emb7b451d7058cc427@mail.gmail.com>


Yeah, NULL is a special case. Nothing is equal to it, not even NULL. By that same token, I doubt that anything is greater than or less than NULL. Give this article a read:

http://thinkoracle.blogspot.com/2005/05/null-vs-nothing.html

Also be sure to read the first comment from HJR.

Don.

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
> >
> >
> >
>
>

-- 
Don Seiler
oracle: http://ora.seiler.us
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 03 2007 - 09:13:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US