The internal representation is true null (e.g null value), not a string substitute for it like [null] or something else. So when you are seeing no value in a data grid or report cell you are really seeng NULL value. PS. Note: In Oracle empty strings and NULLs are the same. To check for a null value you can alsways use something like SELECT nvl(col_name, 'Look here is a NULL'), nvl(col_name2, 'Look here is a NULL too') FROM my_table : I would be glad if I can know the internal representation of Null values and : the select query to see the represented value of null
|