oracle - PL/SQL 输出格式

Question

PL/SQL 输出格式

如输出窗口所示

old:declare

   num1 int; 
begin

    num1:= &enter_num1;
    dbms_output.put_line(num1);  
end;

new:declare

   num1 int; 
begin

    num1:= 102;
    dbms_output.put_line(num1);  
end;
102


PL/SQL procedure successfully completed.

已显示，但我只想要

102


PL/SQL procedure successfully completed.

要显示。有什么建议么.....

标签： oracleplsqlplsqldeveloper

Answer 1

在 SQL*Plus 中，它set verify off解决了这个问题：

这就是你所拥有的：

SQL> set serveroutput on
SQL>
SQL> declare
  2    num1 int;
  3  begin
  4    num1 := &enter_num1;
  5    dbms_output.put_line(num1);
  6  end;
  7  /
Enter value for enter_num1: 102
old   4:   num1 := &enter_num1;
new   4:   num1 := 102;
102

PL/SQL procedure successfully completed.

与set verify off：

SQL> set verify off
SQL> /
Enter value for enter_num1: 102
102

PL/SQL procedure successfully completed.

SQL>