Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Inserting null values
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