SQL> merge into t_test
2 using (select seq_rpt.nextval as pk
3         from dual connect by level<=2
4        ) tmp
5 on (t_test.pk=tmp.pk)
6 when not matched then
7 insert
8 (t_test.pk)
9 values
10 (tmp.pk)
11 /

merge into t_test
using (select seq_rpt.nextval as pk
       from dual connect by level<=2
      ) tmp
on (t_test.pk=tmp.pk)
when not matched then
insert
(t_test.pk)
values
(tmp.pk)

ORA-02287: sequence number not allowed here

小结:1,merge语句，sequence不能处于select中,但可用于insert values中

ITPub博客

merge与ORA-02287: sequence number not allowed here

最新文章