You can use the Oracle IS NOT NULL condition in either a SQL statement or in a block of PLSQL code.
www.techonthenet.com