如何在存储过程中把 select count(*) from tb1的返回值赋给变量,在线等RT[解决办法]SELECT COUNT(*) INTO
如何在存储过程中把 select count(*) from tb1的返回值赋给变量,在线等
RT
[解决办法]
SELECT COUNT(*) INTO V_CNT FROM TB1;
[解决办法]
declare
i int;
j int;
s varchar2(100);
begin
s:= 'select count(*),count(*) from t1 ';
execute immediate s into i,j;
dbms_output.put_line( i );
dbms_output.put_line( j );
end;
//输出结果
1
1
