初用ORACLE,没想到这么麻烦,现在遇到了一个小问题,插入记录的问题,总是提示ORA-00904:"ENDDATA":标识符无效
insert into qz_dict_statcaveitems(stationid,pointid,itemid,samplerate,analogordigital,startdate,enddate,note,illeagle)
values('32573','1','351101','01',1,to_date('2009-01-01','yyyy-mm-dd'),to_date('2009-09-01','yyyy-mm-dd'),' ',2)总是想不通哪的地方错了,请教.谢谢。
insert into qz_dict_statcaveitems(stationid,pointid,itemid,samplerate,analogordigital,startdate,enddate,note,illeagle)
values('32573','1','351101','01',1,to_date('2009-01-01','yyyy-mm-dd'),to_date('2009-09-01','yyyy-mm-dd'),' ',2)总是想不通哪的地方错了,请教.谢谢。
是不是enddate写成了enddata
你检查下,应该是字段名写错了
from qz_dict_statcaveitems where rownum <= 1;insert into qz_dict_statcaveitems
(stationid,pointid,itemid,samplerate,analogordigital,startdate,enddate,note,illeagle)
values
('32573','1','351101','01',1,to_date('2009-01-01','yyyy-mm-dd'),to_date('2009-09-01','yyyy-mm-dd'),' ',2);先查以下,再插入,看看会怎样