Skip Headers

Oracle9i SQL Reference
Release 2 (9.2)

Part Number A96540-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Conditions, 7 of 13


Null Conditions

A NULL condition tests for nulls.

null_condition::=

Text description of conditions4.gif follows
Text description of null_condition


Table 5-9 lists the null conditions.

Table 5-9 Null Conditions
Type of Condition Operation Example
IS [NOT] 
NULL 

Tests for nulls. This is the only condition that you should use to test for nulls.

See Also: "Nulls"

SELECT last_name
  FROM employees
  WHERE commission_pct
  IS NULL;

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback