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

In article <884662894.852754446_at_dejanews.com>, Richard_Popovich_at_Whittman-Hart.com says...
>
>Trying to build an Oracle7.3.2.2 DB with tables that have table
>column's with DEFAULT VALUES.
 

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

I am not sure but off the top of my head you need to drop the comma ie

INSERT INTO foo VALUES(003);

Hope this helps Received on Tue Jan 13 1998 - 00:00:00 CST