but if you think that using two apostrophes will be stored as a space then
you have a little problem.
> -----Oorspronkelijk bericht-----
> Van: William Rogge [SMTP:William_Rogge_at_voltek.com]
> Verzonden: 15-nov-00 15:12
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: RE: null values
>
> Oracle will store a null value in the column, but the cleanest method is
> to
> use the NULL keyword instead of the 2 apostrophes. That way, when the
> code
> is read, there is no confusion as to what is being stored.
>
> -----Original Message-----
> From: GKor_at_rdw.nl [SMTP:GKor_at_rdw.nl]
> Sent: Wednesday, November 15, 2000 8:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: null values
>
> hi all
>
> when i insert a value '' in a varchar2 field with nulls allowed
> this value is stored as a NULL value, is this correct ?
> the developers are not aware of this behavior and they think oracle will
> store a SPACE.
>
>
>
> tia
> g.g. kor
> rdw the netherlands
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: GKor_at_rdw.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: William Rogge
> INET: William_Rogge_at_voltek.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Nov 15 2000 - 08:33:28 CST
