What must be inserted into a NUMBER data type? [message #41181] |
Thu, 05 December 2002 12:38 |
Das
Messages: 92 Registered: November 2002
|
Member |
|
|
Hello all,
I have a table into which I am inserting some records from a file. in the table i have a field of type NUMBER and sometimes this value is blank, so my insert statement looks like this:
insert into ..(myname, mynumber, id)
values('das', , 'a330');
however when the number value is null, I am getting an error: ORA-00936: missing expression
How do we handle this? for example a null character can be replaced with ' '. can i just use NULL ?
I know this is a dumb question, please enlighten me.
thanks
Das
|
|
|
|