如何将count(*)转换为动态sql语句中的temp变量. [英] How to get count(*) into temp variable in dynamic sql stament.

问题描述

嗨...
通常，我们可以将count(*)值放入temp变量中，以进行进一步的计算，例如，

Hi...
Generally we can do to get the count(*) value into temp variable for our further calculation like,

select count(*)into rec_cnt from emp where emp_name = 'DEEPAK';

但是，我想在动态的plsql语句中执行此操作，例如

But , I want to do this in dynamic plsql statement like,

STMT := 'SELECT COUNT(*) INTO REC_CNT FROM '|| tab_name || 'WHERE EMP_NAME = '|| e_name '';
EXCUTE IMMEDITATE STMT;

但以上功能不起作用或不起作用.
您能否帮助我使用动态statemet获取临时变量中的count(*)值?另外，请共享其他任何方法.

but above is not functional or not working.
Can you pls help me to get the count(*) value in temp variable using dynamic statemet? also, pls share any other approach if any.

推荐答案

yupp ...
我得到了解决方案...非常简单....

喜欢

STMT:=''选择COUNT(*)FROM''|| tab_name || " WHERE EMP_NAME =" || e_name ||;
立即执行STMT到REC_CNT;

现在，REC_CNT将包含COUNT(*)的值.

yupp...
i got the solution...its very simple....

like

STMT := ''SELECT COUNT(*) FROM '' || tab_name || '' WHERE EMP_NAME = ''|| e_name ||;
EXECUTE IMMEDIATE STMT INTO REC_CNT;

Now, REC_CNT will contain the value of COUNT(*) .

这篇关于如何将count(*)转换为动态sql语句中的temp变量.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！