如何在不使用序列名称的情况下引用序列 [英] how to refer sequence without using sequence name
本文介绍了如何在不使用序列名称的情况下引用序列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
解决方案
hi
使用这样的动态查询:
声明
seqName varchar2(100);
seqVal number;
begin
立即执行select|| seqName || .nextval from dual进入seqVal;
结束;
/
i have one table. there are 6 columns.in that one column is auto generation.but i did't autogenerate. simply i have given sequence name.using function i have stored sequence name in one variable.how to refer sequence without using sequence name (ie) sequencename.nextval.. instead of that i should refer using variable (ie) variable.nextval... how to do
解决方案
hi use dynamic query like this:
declare
seqName varchar2(100);
seqVal number;
begin
execute immediate "select " || seqName || ".nextval from dual" into seqVal;
end ;
/
这篇关于如何在不使用序列名称的情况下引用序列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文