From: stunaz on
i finally found it here is the answer :

EXECUTE IMMEDIATE ('ALTER TABLE MAILS_TEMPLATES ADD (SEND_ITEM
VARCHAR2(1) DEFAULT ''N'' NOT NULL)');