oracle插入语句总提示缺少豆号 给看哈怎么回事
"insert into userinfo values(gai_web.nextval ,'godddff','godlove','','','1990-2-12 0:00:00',0,'2011-12-13 17:10:46','asdf@125.com',0,0,0,'2011-12-13 17:10:46','127.0.0.1',1" --------------------编程问答-------------------- 少) 最后没有括死 --------------------编程问答-------------------- 时间类型的还要 to_date('2011-12-13 17:10:46','yyyy-mm-dd hh24:mi:ss') --------------------编程问答-------------------- 搞了半天奶奶的个熊 你一语经醒梦中人呐 40分全给你了 --------------------编程问答-------------------- insert into userinfo values(gai_web.nextval ,'godddff','godlove',
'','','1990-2-12 0:00:00',0,
'2011-12-13 17:10:46','asdf@125.com',0,0,0,
'2011-12-13 17:10:46','127.0.0.1',1) --------------------编程问答-------------------- "insert into userinfo values('"+gai_web.nextval+"','godddff','godlove',' ',' ','1990-2-12 0:00:00',0,'2011-12-13 17:10:46','asdf@125.com',0,0,0,'2011-12-13 17:10:46','127.0.0.1',1)" --------------------编程问答-------------------- +1 --------------------编程问答-------------------- --------------------编程问答-------------------- --------------------编程问答-------------------- 楼主好粗心啊 仔细点就好了
起始我也经常犯低级的错误! --------------------编程问答--------------------
出现这种问题的时候最好先用断点调试出sqltext的值,一目了然了
补充:.NET技术 , C#