你把stu_basic_infor_seq.nextval去掉,在表后面加上字段名,你这样试试看。
MSSQL中这样可以的。"insert into eduinfo.stu_basic_infor() values (stu_basic_infor_seq.nextval,2,2,2,'fdsa','asdf','m','fsa','fsda','fdsa','dfsaf','fdsaf')");
MSSQL中这样可以的。"insert into eduinfo.stu_basic_infor() values (stu_basic_infor_seq.nextval,2,2,2,'fdsa','asdf','m','fsa','fsda','fdsa','dfsaf','fdsaf')");
A another method,you can get the "stu_basic_infor_seq.nextval" first,and then you insert the oracle.
"select stu_basic_infor_seq.nextval from dual"
真的搞不懂了!为什么在pl/sql里面就可以,在java里面用PreparedStatement 和 ResultSet 就得不到我想要的东西呢?
not "mytable"
It's must be "dual"
是seq的用户没有建立的问题!
为什么非要选择from dual呢?dual到底是什么东西,我初学,还弄不明白。