CODEWITHSUNDEEP
sqlora-00904
Steffi
Steffi

Reputation: 31

SQL Error: ORA-00904: : invalid identifier

I am an SQL rookie and I would very much appreciate some assistance on this rather basic issue.

alter table OCEAN_ANTENNE_TEMP
add column ANT_TILT_M number(5) not null,
ANT_FSC_ANT number(4,1) default 0;
/

why is this query giving me this error:

SQL Error: ORA-00904: : invalid identifier 00904. 00000 - "%s: invalid identifier"

Upvotes: 3

Views: 35062

Answers (2)

vhadalgi
vhadalgi

Reputation: 7189

alter table OCEAN_ANTENNE_TEMP 
add (ANT_TILT_M number(5) default 0 not null, 
      ANT_FSC_ANT number(4,1) default 0 not null);

See here for correct syntax

See here for Documentation

Upvotes: 2

simplify_life
simplify_life

Reputation: 405

correct method is

alter table OCEAN_ANTENNE_TEMP 
add ( ANT_TILT_M number(5) not null, 
ANT_FSC_ANT number(4,1) default 0);

Upvotes: 2

Related Questions