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: 无效列名
------解决方法--------------------------------------------------------
