Why does assigning a default value cause invalid identifier error?

[Anthony Herrera]


CREATE TABLE CP_INTFDC (ID_ACQ_IIC number(11,0) not null,
ID_FWD_IIC number(11,0) not null,
ID_INCOMING_TIM ER number(6,0) DEFAULT 600 NOT NULL,
ID_OUTGOING_TIM ER number(6,0) DEFAULT 30 NOT NULL,
ID_STDIN_IND varchar2(1) DEFAULT 2 NOT NULL,
);

I am having a problem invalid indentifier when i have a default value and also have a not null set it during creation.

Please help.

[debasisdas]

use this

CREATE TABLE CP_INTFDC (ID_ACQ_IIC number(11,0) not null,
ID_FWD_IIC number(11,0) not null,
ID_INCOMING_TIMER number(6,0) DEFAULT 600 NOT NULL,
ID_OUTGOING_TIMER number(6,0) DEFAULT 30 NOT NULL,
ID_STDIN_IND varchar2(1) DEFAULT '2' NOT NULL
);