Re: Inserting null values

From: Dave A <dave_and_vanna_at_hotmail.com>
Date: Tue, 26 Sep 2000 20:23:08 -0500
Message-ID: <st2ikht0d60v01@corp.supernews.com>

Try this:

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

--
Dave A


"Steve" <stephen.howard_at_us.pwcglobal.com> wrote in message
news:NAbA5.16719$Ic.242039_at_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 - 20:23:08 CDT