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 -> Inserting null values

Inserting null values

From: Steve <stephen.howard_at_us.pwcglobal.com>
Date: Wed, 27 Sep 2000 00:56:13 GMT
Message-ID: <NAbA5.16719$Ic.242039@typhoon.columbus.rr.com>

I am having a problem figuring out how to insert a null value when it is the last value in a string.

EXAMPLE INSERT INTO MY_TABLE(COL1,COL2,COL3) VALUES('I','need',);

fails, if the last column is a number datatype. I really don't want to use NVL, because if it is null, I would like to leave it that way. I don't know if the last column will receive a value or not until the statement is processed, but it can be null in the database. In other words, I don't think that just dropping the COL3 off of the columns section will solve my problem. Am I missing something basic?

Many Thanks, Steve Received on Tue Sep 26 2000 - 19:56:13 CDT

Original text of this message

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