Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trouble inserting record into ORACLE TABLE having column with default values

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

From: Peter Verhaegen <peter.verhaegen_at_mace.be>
Date: 1998/01/13
Message-ID: <34BB1A72.AB62445C@mace.be>#1/1

The first 2 seem OK. You specify a value , even if it is NULL, and this is in the table.
The third should be

INSERT INTO foo VALUES(003);

so without the comma. Received on Tue Jan 13 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US