Re: Null values and Varchar2 fields

Filip Hanik wrote on 24-Jul-99 02:21:27:
>Hi,
>I have a question,
>how come when I set a column (type varchar2) to be a zero length string
>('') the value gets ignored and the column is null?

Hello Filip,
that's the way Oracle works. Empty strings are equivalent to null values.

>thanks
>Filip

Hope that helps,
Lothar

--
Neue Adresse ab 10.07.'99:

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Hauptstr. 26            | lothar.armbruester_at_t-online.de
D-65346 Eltville        |