merge与ORA-02287: sequence number not allowed here

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博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-755345/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-755345/