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

Home -> Community -> Usenet -> c.d.o.misc -> Oracle's treatment of null and empty string

Oracle's treatment of null and empty string

From: Paul Jackson <ragoczy_at_SolarBears.fan.org>
Date: 1998/02/13
Message-ID: <34e4b4f2.6487569@news.gdi.net>#1/1

I'm a developer and our DBA told us today that Oracle 7.3 makes no distinction between a null value and an empty string in varchar or varchar2 column.

I.E. <null> means the same as "" and an insert or update setting column_name = "" will actually set it to null and violate a not null constraint for that column.

Could anyone clarify or confirm this?

Thanks
Paul Jackson Received on Fri Feb 13 1998 - 00:00:00 CST

Original text of this message

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