I ran into an unexpected error the other day using TOAD. I was trying to add a new column to a table which shouldn’t have been too difficult. It seems that while using that “add column” form that TOAD provides, you still need to put single-quotes around the default value (‘N’) in the default field.
ALTER TABLE users ADD (is_locked CHAR(1 BYTE) DEFAULT N);
TOAD was giving me this! Grrr…
Useful resources if you like: