请问我想将count(*)的值给row_count,但是提示错误说我没定义,我明明已经定义了的,这个问题2天没解决,但对你来说很简单了,谢谢了
DECLARE
row_count number; --得到记录的条数
sqlstr varchar2(1000); BEGINsqlstr:='select count(*) into row_count from '|| site ||'_tbsendcardlist where simcardnum = '||SIMCARDNUM||'';execute immediate sqlstr;
DECLARE
row_count number; --得到记录的条数
sqlstr varchar2(1000); BEGINsqlstr:='select count(*) into row_count from '|| site ||'_tbsendcardlist where simcardnum = '||SIMCARDNUM||'';execute immediate sqlstr;
SQL>
SQL> DECLARE
2 row_count number; --µÃµ½¼Ç¼µÄÌõÊý
3 BEGIN
4 execute immediate 'select count(*) from t2 ' into row_count;
5 dbms_output.put_line(row_count);
6 end;
7 /0PL/SQL procedure successfully completedSQL>
row_count number; --得到记录的条数
sqlstr varchar2(1000);
BEGINsqlstr:='select count(*) into row_count from '|| site ||'_tbsendcardlist where simcardnum = '||SIMCARDNUM||'';execute immediate sqlstr;site ,SIMCARDNUM这两个变量没有定义。