sql - Add Column to Table -

i looked around answer this. how add column using sql in oracle database.

i keep finding same answer, oracle sql developer tool keeps telling me syntax wrong though write do.

what missing exactly? (before ask, yes use alter table before this)

the syntax supposed be:

add column_name constraint data_type;

issue is, have no constraints column i've seen examples not use it. tried , same error. value can null , have no constraints, yet not allowed this:

add series_year number(2,10);

any suggestions? it's incredibly simple.

edit: here error gives me:

error

you missing parentheses. try following:

alter table      foo add (     series_year number(2,10) not null, );

you have write data type before constraint, not opposite, like:

add (     column1_name column1_datatype column1_constraint,       column2_name column2_datatype column2_constraint );

And