oracle 无效列名 00904,ORA-00904: 无效列名,解决方法!

SQL> desc emc_linkstudy_log;

名称 空? 类型

----------------------------------------- -------- ----------------------------

PKID NOT NULL NUMBER(12)

STUDY_TIME NOT NULL DATE

USER_NAME NOT NULL VARCHAR2(400)

TRAN_STATION_ID NOT NULL VARCHAR2(400)

RECV_STATION_ID NOT NULL VARCHAR2(100)

MODEL_TYPE NOT NULL VARCHAR2(100)

MODEL_PARAM NOT NULL VARCHAR2(4000)

RECV_PARAM NOT NULL VARCHAR2(100)

DX_INC NOT NULL NUMBER(7,5)

BUILDING NOT NULL VARCHAR2(10)

CLUTTER NOT NULL VARCHAR2(10)

TERRAIN NOT NULL VARCHAR2(10)

STUDY_TITLE VARCHAR2(200)

STUDY_REMARK VARCHAR2(200)

SQL> insert into Emc_LinkStudy_Log values(1,TO_DATA('2006-11-22 11:11:13','YYYY-MM-DD HH24:MI:SS'),'

szUserName','TL112211111','TL112211','0','1','dsfdf',0.0000,'0','0','0','jj','jj');

insert into Emc_LinkStudy_Log values(1,TO_DATA('2006-11-22 11:11:13','YYYY-MM-DD HH24:MI:SS'),'szUse

*

ERROR 位于第 1 行:

ORA-00904: 无效列名

------解决方法--------------------------------------------------------