PL/SQL: ORA-00984: column not allowed here

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: