为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:linux
【CPU】:x86
【问题描述】*:
版本:
SQL> SELECT * FROM V$VERSION;
行号 BANNER
1 DM Database Server 64 V8
2 DB Version: 0x7000c
3 03134284172-20240321-222308-20093
4 Msg Version: 0
5 Gsu level(3-4) cnt: 3
6 Gsu level(5) cnt: 0
6 rows got
执行语句报错:
SQL> with a as (select * from tab1) insert into tab1 select * from a;
with a as (select * from tab1) insert into tab1 select * from a;
with a as (select * from tab1) insert into tab1 select * from a;
*
第 1 行, 第 58 列[insert]附近出现错误[-2007]:语法分析出错.
已用时间: 3.111(毫秒). 执行号:0.
试一下修改成下面这个写法是否还报错
insert into tab1 with a as (select * from tab1) select * from a;
貌似24年7月及以后的版本能支持你期望的写法