Null value in oracle 11g

Post a Comment. This bug is known for Oracle, and I'm sure they will fix it in next build. For now, there are two paths for us. First is to ignore it, and test with next build, when it will be available.

Second is to apply temporal workaround, until bug will be fixed by Oracle. In my opinion, you should follow second path, if you have critical need to be able to set Null value for LOV before next build will be available from Oracle. For example, null added to 10 is null.

In fact, all operators except concatenation return null when given a null operand. You can use the NVL function to return a value when a null occurs. Most aggregate functions ignore nulls. For example, consider a query that averages the five values , null, null, null, and Home » Articles » Misc » Here.

This article provides a summary of the functions available for handling null values. For a more detailed description follow the links are the bottom of the article. The NVL function allows you to replace null values with a default value.

If the value in the first parameter is null, the function returns the value in the second parameter. If the first parameter is any value other than null, it is returned unchanged. We know that COL1 in the test table contains null in all rows except the first.