Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Object Oriented

 

NULL objects and NULL attributes

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>