Re: Make a field have Default Values? (Table Creation)

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 23 Apr 1999 12:48:00 +0200
Message-ID: <7fpj4j$cv1$1@weber.a2000.nl>

Peter L wrote
> An on_insert trigger on table test could be used
> to add the default value.

... which indeed is to be preferred when you also want to force the value to be zero when the user inserts null. Note that in:

    insert into test( id, parts )
      values( 1, null );

the default value is NOT used, but null is inserted instead of your default. Only when using

    insert into test( id )
      values( 1 );

the default value would be used for column parts. To get Lisa started:

    create or replace trigger biu_test

        before insert or update on test
        for each row
    begin
        :new.parts := nvl( :new.parts, 0 );

    end biu_test;
    /
    show errors

Arjan. Received on Fri Apr 23 1999 - 05:48:00 CDT