I guess you're going to have to define what an Empty String is for us,=20
before we can answer that question.
Can you use a string with one space? If you insert the value "" into a=20
field in an Oracle database, it's going to interpret that as a NULL.
Get back to us.
Lyall Barbour
At 05:57 AM 8/16/00 -0800, you wrote:
>Hi,
>we have external programs reading values from Oralce8 database that need an
>empty string, if no other value is available - i.e. instead of NULL: How=
can
>I tell Oracle that there is a difference between NULL ( nothing) and an
>empty string? ANd how can I tell my column to use the empty string as
>default value?
>
>Regards,
>Antje Sackwitz
>
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>Antje Sackwitz
>Vossloh System-Technik GmbH
>Edisonstra=DFe 3
>24145 Kiel
>
>Tel. +49 431 7109 514
>Fax. +49 431 7109 675
>eMail sackwitz_at_vst.vossloh.de
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
>--
>Author: Sackwitz, Antje
> INET: Sackwitz_at_vst.vossloh.de
>
>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 Aug 16 2000 - 12:51:21 CDT
