Q: How can I insert a null value into a numeric field in the database? I tried not giving a #variable a value but that did not work, 0 was inserted.
A: When doing the insert, list only the fields for which a value is known. All other fields will get the null value. Here is sample code for inserting into the following table:
Name Null? Type
------------------------------- -------- ----
name no varchar2(24)
job yes varchar2(24)
id no number
deptno yes number
---------------------------- Example code begins here --------------------------
begin-sql
insert into table1 (name,id) values ('Jones',1)
end-sql
---------------------------- Example code ends here ---------------------------