SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

varchar2() null vs empty string

355896Oct 18 2002

I am trying to insert a string '' ( zero length string) into a varchar(20) not null column using sqlplus. Oracle gives me back an error saying can not insert null in a not null column.
Why does oracle considers '' as null ? How can I fix it?

Same SQL works fine in SQL server.

Thanks,
Shailendra.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 15 2002

Added on Oct 18 2002

4 comments

1,787 views