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

Home -> Community -> Usenet -> c.d.o.server -> Re: NULLs are now always NULLs ?

Re: NULLs are now always NULLs ?

From: BJ <bj_at_a.com>
Date: Wed, 22 Mar 2006 18:47:00 +0000
Message-ID: <7p6322tq1m0s47m77346eqhs8qdbsi33ha@4ax.com>


On Wed, 22 Mar 2006 10:27:44 -0500, "Syltrem" <syltremzulu_at_videotron.ca> wrote:

>
>This is what I expect, both syntax NULL and '' represent a null value;
>
>Then why does it make a difference here ?
>SQL> exec dbms_system.set_ev(100,200,10046,4,'') --> works just fine
>SQL> exec dbms_system.set_ev(100,200,10046,4,null) --> does not work (does
>not generate a trace file)
>

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements005.htm#i59110

"Note:
Oracle Database currently treats a character value with a length of zero as null. However, this may not continue to be true in future releases, and Oracle recommends that you do not treat empty strings the same as nulls." Received on Wed Mar 22 2006 - 12:47:00 CST

Original text of this message

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