oracle插入语句报错

Question

[SQL]insert into CA_ORGANIZATION ( uid ,createtime ,oname ,ocode ,oid ) values('1','1','1','1','1')[Err] ORA-00928: missing SELECT keyword

Answer 1

createtime应该是日期型，但你的值是字符型，怎么可以这样写。字段类型和赋值要一至。