Re: Urgent!!! Null and empty string problem

In Access you would try to insert an empty string but in Oracle it would be a null value:

something like:

INSERT INTO mytable VALUES ('Hello',null);

Jean-louis Lamacchia

Mike Ng wrote in message <38c86392_1_at_news1.prserv.net>...
>hi all,
>
>I'm trying to insert a value empty string ( '' ) into a field which is not
>null but it prompt me error message. In other database, it is different
>between empty string and null, and allow adding the empty string to the
>field which is not null. However, the Oracle seems to be confuse them. Can
>anyone give me some hints so I can do that?
>
>Thank you
>
>Regards,
>Mike
>
>
Received on Fri Mar 10 2000 - 08:50:50 CST