ied Professional
>
>
> -Original Message-
> From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 18, 2003 4:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Empty String is interpreted as NULL
>
>
> Hello all,
> Suppo
How about inserting 'NULL'? No, I am not kidding... The following is taken from an
actual system...
columnA has a NOT NULL constraint
columnA has a CHECK constraint with a list of acceptable values, one of them is 'NULL'
BTW, I don't recommend either approach. NULL has a special meaning to Orac
using.
> -Original Message-
> From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 18, 2003 4:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Empty String is interpreted as NULL
>
>
> Hello all,
> Sup
Reuben,
While I agree that an empty string is not logically equal to a null, Oracle
interprets an empty string in INSERT and UPDATE statements as a NULL. So
you really do not have a choice here. If you have the need to insert an
empty string into a column, you have two choices:
- Define a chara
Hello all,
Suppose I have this table
SQL> DESC FRUIT
Name Null?Type
-
ORANGENOT NULL VARCHAR2(10)
APPLE NOT NULL VARCHAR2(10)
If I