Re: Trouble inserting record into ORACLE TABLE having column with default values

Default values will be used only when associated columns are not presents in insert statement. If you don't give a value for each column in you insert, then you must specified columns names in the statement like this :

insert into foo (id) values (4) ;

This way, you'll get the default value.

TRF Richard_Popovich_at_Whittman-Hart.com a écrit dans l'article <884662894.852754446_at_dejanews.com>...
> 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
>
Received on Tue Jan 13 1998 - 00:00:00 CST