Hi all. Converting an ASP from SQL server to Oracle. There is an insert statement on one of the pages that puts " " into a column of the number datatype. In oracle, when I try to insert " " into a number column, I get the ORA-01722: invalid number error. (Of course that isn't very surprising) So my question is, what is best practice when it comes to something like this? Should I just have it populated with "0" if the column to be inserted is null? Or should I change the datatype to varchar or something of that nature so I can insert " " 's? As far as I can see, there is no type of indexing or constraints on this column...Is changing the datatype a bad move?
Okay, so my original question aside...if you have a number column in an oracle table, and you do not want to insert a value into the column (of "number" data type) what do you insert? (if i try to insert "NULL" i get the same error)