insert into stud(sno,sname,sex,tel,email,birthday,mno,majorno)
select '8208190101','张一鸣','男','15546821504','1579205483@qq.com',2000-10月-21,'8208190110','01' from SYS.dual
union all select '8208190101','张一鸣','男','15546821507','1579205483@qq.com',2000-10月-30,'8208190110','01' from SYS.dual
union all select '8208190102','张二鸣','女','15543251506','9544105372@qq.com',2001-1月-21,'8208190110','01' from SYS.dual
union all select '8208190103','张三鸣','男','14586821504','2485103871@qq.com',2000-7月-12,'8208190110','01' from SYS.dual;
批处理插入数据,但是运行的报错信息为
SQL 错误: ORA-00923: 未找到要求的 FROM 关键字
00923. 00000 - "FROM keyword not found where expected"
*Cause:
*Action:
请问问题出在哪里,怎么解决?