I have the following table defined:
CREATE TABLE testtable
id NUMERIC (20, 0) NOT NULL,
“name” CHARACTER VARYING (100) NOT NULL
In Toad Edge 2.0.2 when I use the “Data” tab of the table viewer and I insert a new record, I cannot figure out a way to insert a null value into the “name” column!
I click the plus icon to add a new row to the table. Then I double click on the “name” column, enter some string like “test 123”, and press Enter. Then I double click on the “name” column again and try to set it to a null value, but when I erase the contents of the field and press Enter, the value saved to the field is a blank string, not a null value.
How do I use the table viewer to enter a null value into a field? in Toad for Oracle, when I erase the contents of a column in a record using the table viewer, the value is set to null.