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 -> NULL v. null string

NULL v. null string

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Sat, 21 Jul 2001 21:35:59 GMT
Message-ID: <1hvtkt0ggngfnendsgejsodpko3d2e04l5@4ax.com>

If NULL is not the same as a null string, then why does this block of code display 'YES'.

begin
  if '' is null then
    dbms_output.put_line('yes');
  else
    dbms_output.put_Line('no');
  end if;
end;

Same this with this. If null string is a known value and NULL is an unknown value, why does this display no?

begin
  if '' = '' then
    dbms_output.put_line('yes');
  else
    dbms_output.put_Line('no');
  end if;
end;

--
Chuck Hamilton
chuck_hamilton_at_yahoo.com

"Do not be deceived, God is not mocked; 
for whatever a man sows, this he will also
reap." (Gal 6:7 NASB)
Received on Sat Jul 21 2001 - 16:35:59 CDT

Original text of this message

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