SQL> insert into YN_9110_DYS_90 values('2010-10-01','123','1','444','90','1234456',2);
insert into YN_9110_DYS_90 values('2010-10-01','123','1','444','90','1234456',2)
ORA-01861: literal does not match format string
SQL> show errors;
No errors
SQL>
数据库中有7个字段,第一个是data,第二个到第六个为char,最后一个是number
错误是什么东西不匹配string类型嘛? 各位大侠走过路过来帮忙解决一下啊!
日期格式要转换
顺便问一下,插入语句如果写在C#里面要怎么写呢,字段都需要用站位符代替
把上面的语句写成C#里面的,谢谢啦!!!!
insert into YN_9110_DYS_90
values(to_date('2010-10-01','yyyy-mm-dd'),'123','1','444','90','1234456',2);
insert into YN_9110_DYS_90 values(to_date('2010/10/01','yyyy-mm-dd'),'123','1','444','90','1234456',2)insert into YN_9110_DYS_90 values(to_date('2010/10/01','yyyy-mm-dd'),'123','1','444','90','1234456',2);
CommandText = "insert into user values(:para1,:para2;Id,name)";
定义OracleParameter,有很多重载很好用从MSDN上看看吧,这个很简单