Trouble inserting record into ORACLE TABLE having column with default values

Trying to build an Oracle7.3.2.2 DB with tables that have table column's with DEFAULT VALUES.

I have a table similar to the following example:

CREATE TABLE foo( id NUMBER(4),

                     description VARCHAR2(20) DEFAULT 'Unassigned');

When I insert the following records:

[1]

  INSERT INTO foo VALUES(001, NULL);
1 ROW CREATED.
[2]

  INSERT INTO foo VALUES(002, ' ');
1 ROW CREATED.
[3]

  INSERT INTO foo VALUES(003, );
ERROR at line 1:
ORA-00936: missing expression

SQL> SELECT * FROM foo;

       ID NAME

--------- --------------------
        1
        2

I am not able to get the DEFAULT VALUE for FOO.NAME.

Appreciate any/all input,

Rich

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet