Error in alter table statment

[Satheeshkumar N]

"ALTER TABLE MOVIE ADD ( MULTIPLEX NUMBER(3))"

while i'm trying to execute this query ...

Its displayed as 'SYNTAX ERROR IN FIELD DEFINITION'

Pls help me....

 

[PARSO]

try this

ALTER TABLE movie ADD MULTIPLEX NUMBER NULL;