Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

difference between NULL and ''

NeilCSEMar 30 2010 — edited Mar 30 2010
Hi All,

Is the below right?

NULL is not stored as a value in a field. Its an internal bit that is set to indicate that the value is unknown.
Blank is stored as a value in the field. Because of that we can perform all kinds of comparisons with blank value, while we cant do the same with NULLs

Regards,
aak

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 27 2010
Added on Mar 30 2010
13 comments
25,470 views