Define Is Null operator

Define Is Null operator.

- To test for nulls, use only the comparison conditions IS NULL and IS NOT NULL.
- If you use any other condition with nulls and the result depends on the value of the null, then the result is UNKNOWN.
- As a null represents a lack of data, a null cannot be equal or unequal to any value or to another null.
- However, Oracle considers two nulls to be equal when evaluating a DECODE function.
- Oracle also considers two nulls to be equal if they appear in compound keys.
- That is, Oracle considers identical two compound keys containing nulls if all the non-null components of the keys are equal.

Example:
select * from student
where student_name IS NOT NULL;
What is NVL() function?
Oracle deals with Null values using NVL function. The function replaces the NULL value in the given column with the value provide to it...
Oracle union, intersect and minus
Oracle union, intersect and minus - UNION: The UNION operator is used to combine the result-set of two or more SELECT statements Tables of both the select statement must have the same number of columns with similar data types. It eliminates duplicates.......
What is composite data type?
Collections are usually referred to as Composite Data types...
Post your comment