请高手帮忙解决下:with a as
(select 1, 2 from dual),
b as
(select 3, 4 from dual)
insert into dual select a.*, b.* from a, b;报错:缺少select 关键字 为什么? 在线等。
(select 1, 2 from dual),
b as
(select 3, 4 from dual)
insert into dual select a.*, b.* from a, b;报错:缺少select 关键字 为什么? 在线等。
解决方案 »
- 在oracle端限制某个字段值不可重复
- oracle中一些语句不明白的地方
- 程序连接不上Oracle的问题
- 菜鸟求助!Oracle Client无法安装问题!
- oracle9i安装不完全时怎么卸载?
- oracle9导出的dmp文件,在oracle8中怎么导入?[问题解决,立即给分,另再送100]
- 存储过程的参数传递
- 我在oracle 的SQL PLUS里插的数据怎么看不倒??
- 急!急!急!关于ORACLE下插入BLOB字段后不能提交的问题
- 关于数据库检索时,先对结果集UNION再做LEFT JOIN,与先做LEFT JOIN再做UNION,检索出的结果集会不同么,如果相同哪个性能好呢!!急急急
- PLSQL的导入导出工具问题
- 用sqldlr怎么导入dat文件到ORACLE数据库不同的表中
--加insert into dual做什么?改下试试
with a as
(select 1, 2 from dual),
b as
(select 3, 4 from dual)
select a.*, b.* from a, b;
insert into dual
with a as
(select 1, 2 from dual),
b as
(select 3, 4 from dual)
select a.*, b.* from a, b;
insert into XXX
with a as
(select 1, 2 from dual),
b as
(select 3, 4 from dual)
select a.*, b.* from a, b;