NULL objects and NULL attributes : Object Instance « Object Oriented « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Object Oriented
3. Object Instance

SQL>
SQL> CREATE OR REPLACE TYPE address AS OBJECT
  2              (line1 VARCHAR2(20),
  3               line2 VARCHAR2(20),
  4               city VARCHAR2(20),
  5               state_code VARCHAR2(2),
  6               zip VARCHAR2(13));
  7  /

Type created.

SQL> DECLARE
  2    addressValue address;
  3  BEGIN
  4
  5    addressValue := address('27 Rd','#99','E','NJ','08820');
  6    addressValue := NULL;
  7    IF (addressValue IS NULL) THEN
  8      DBMS_OUTPUT.PUT_LINE('addressValue is atomically null');
  9    END IF;
 10  END;
 11  /
addressValue is atomically null

PL/SQL procedure successfully completed.

SQL>