pl/sql 程序块里打印问题

declare v_number NUMBER;
 v_number2 NUMBER;
begin
select count(*) into v_number from dual;
DBMS_OUTPUT.PUT_LINE('table YJBZH_GRXDFHZMXJL此时记录数为'||v_number);
select count(*)  into v_number2  from t1;
DBMS_OUTPUT.PUT_LINE('table YJBZH_GRXDFHZMXJL此时记录数为'||v_number2);
end;


declare v_number NUMBER;
 v_number2 NUMBER;
begin
select count(*) into v_number from dual;
DBMS_OUTPUT.PUT_LINE('table YJBZH_GRXDFHZMXJL此时记录数为'||v_number);

begin
select count(*)  into v_number2  from t1;
DBMS_OUTPUT.PUT_LINE('table YJBZH_GRXDFHZMXJL此时记录数为'||v_number2);
end;
end;

在一个程序块里,是end结束才打印。

原文地址:https://www.cnblogs.com/zhaoyangjian724/p/3798030.html