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:

Tags: , , , ,

Thursday, July 14th, 2011 Database, Oracle

Leave a Reply

 

Comments are moderated due to spammers. Your comments will not appear until I review and approve them. If you left a question I will answer as best I can so be sure to check back.