当前位置: 动力学知识库 > 问答 > 编程问答 >

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"

网友答案:

correct method is

alter table OCEAN_ANTENNE_TEMP 
add ( ANT_TILT_M number(5) not null, 
ANT_FSC_ANT number(4,1) default 0);
网友答案:
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

分享给朋友:
您可能感兴趣的文章:
随机阅读: