Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 22567 invoked from network); 7 Aug 2007 15:38:14 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 7 Aug 2007 15:37:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 107B971E2F6; Tue, 7 Aug 2007 16:10:35 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29290-02; Tue, 7 Aug 2007 16:10:34 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8761F720076; Tue, 7 Aug 2007 16:10:34 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 07 Aug 2007 15:24:21 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 79B607215D1 for ; Tue, 7 Aug 2007 15:24:21 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23941-05 for ; Tue, 7 Aug 2007 15:24:21 -0400 (EDT) Received: from mx01.il.proquest.com (mx00.il.proquest.com [192.195.245.51]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C6C671FD8C for ; Tue, 7 Aug 2007 15:22:43 -0400 (EDT) X-ASG-Debug-ID: 1186514689-57c6000d0000-JbYmij X-Barracuda-URL: http://spam.il.proquest.com:8000/cgi-bin/mark.cgi X-Barracuda-Connect: aabo-exchange05.bos.il.pqe[172.24.3.61] X-Barracuda-Start-Time: 1186514689 X-ASG-Whitelist: Client Received: from aabo-exchange05.bos.il.pqe (aabo-exchange05.bos.il.pqe [172.24.3.61]) by mx01.il.proquest.com (Spam Firewall) with ESMTP id 320CDD011092; Tue, 7 Aug 2007 15:24:49 -0400 (EDT) Received: from AABO-EXCHANGE02.bos.il.pqe ([172.24.3.206]) by aabo-exchange05.bos.il.pqe with Microsoft SMTPSVC(6.0.3790.3959); Tue, 7 Aug 2007 15:24:49 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7D928.9E948DCC" X-ASG-Orig-Subj: RE: CHR(0) ver null Subject: RE: CHR(0) ver null Date: Tue, 7 Aug 2007 15:26:20 -0400 Message-ID: In-Reply-To: <9fc1ae810708071118k3f3fbbcbi605f3db4dd8aae6f@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: CHR(0) ver null References: <9f0e18730708021144p1beb5e95l45951801d7867dfc@mail.gmail.com> <9fc1ae810708071118k3f3fbbcbi605f3db4dd8aae6f@mail.gmail.com> From: "Bobak, Mark" To: , Cc: X-OriginalArrivalTime: 07 Aug 2007 19:24:49.0034 (UTC) FILETIME=[9ED9C6A0:01C7D928] X-Barracuda-Virus-Scanned: by Barracuda Spam Firewall at il.proquest.com X-archive-position: 377 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-to: Mark.Bobak@il.proquest.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C7D928.9E948DCC Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Lex would have liked that a lot, I'm sure.... J =20 -- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak@il.proquest.com =20 www.proquest.com =20 www.csa.com =20 ProQuest...Start here.=20 =20 From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ram Srinivasan Sent: Tuesday, August 07, 2007 2:19 PM To: tomdaytwo@gmail.com Cc: oracle-l@freelists.org Subject: Re: CHR(0) ver null =20 Hi Guys: =20 Null <> CHR(0). In fact NULL is totally imbecile. Here is a poem I wrote long time ago. =20 ------------------------------------------Ode to Null =20 =20 It is neither a mountain nor a creek;=20 It is neither Latin nor Greek;=20 It is neither strong nor weak;=20 It is neither courageous nor meek.=20 =20 It is neither nothing nor something;=20 It is neither a good thing nor a bad thing;=20 It is neither a big thing nor a small thing;=20 But it is something we have to deal with among all things.=20 =20 It is neither a lender nor a borrower;=20 It is neither a zero nor a blank;=20 It is neither here nor there;=20 But, in programming, it is everywhere.=20 =20 Oh! NULL, Oh! NULL!=20 You are neither a push nor a pull;=20 You always make us mull=20 Ov'r your dangerous effects, Oh! NULL!=20 =20 =20 Ram Srinivasan 21-Feb-2000 =20 ------------------------------------------------------------------------ ------------------------------------------- =20 On 8/2/07, Thomas Day wrote:=20 This works perfectly fine for me in 10.2 =20 select OWNER, TABLE_NAME from dba_TABLES where owner >=3D CHR(0) AND TABLE_NAME >=3D CHR(0) ORDER BY 1,2 On the other hand "null" is undefined. It's not CHR(0). =20 =20 On 8/2/07, Wojciech Skrzynecki wrote:=20 Hello What component in DB I have to install to use ">=3D CHR(0)" instead of "is not null" .=20 -- Wojciech Skrzynecki Database Administrator -- http://www.freelists.org/webpage/oracle-l=20 =20 --=20 Sincerely Ram Srinivasan Charlottesville, VA.=20 ------_=_NextPart_001_01C7D928.9E948DCC Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Lex would have liked that a lot, I’m sure…. = J

 

--
Mark J. Bobak
Senior Database Administrator, System & Product = Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x = 4059
mark.bobak@il.proquest.com www.proquest.com
www.csa.com

ProQuest...Start here.

 

From:= = oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ram = Srinivasan
Sent: Tuesday, August 07, 2007 2:19 PM
To: tomdaytwo@gmail.com
Cc: oracle-l@freelists.org
Subject: Re: CHR(0) ver null

 

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@gmail.com> = wrote:

This works perfectly fine for me in = 10.2

 

select OWNER, TABLE_NAME from dba_TABLES where = owner >=3D CHR(0)
AND TABLE_NAME >=3D 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@gmail.com > wrote:

Hello

What component in DB I have to install to use  ">=3D CHR(0)" instead of
"is not null" .



--
Wojciech Skrzynecki
Database Administrator
--
http://www.freelists.org/webpage/oracle-l

 




--
Sincerely
Ram Srinivasan
Charlottesville, VA.

------_=_NextPart_001_01C7D928.9E948DCC-- -- http://www.freelists.org/webpage/oracle-l