Question

Oracle中变量如何输出？

Create or replace procedure Sel is AA date;begin Select sysdate into AA from dual;end;/execute Sel; 如何输出AA???

Answer 1

存储过程直接打印Create or replace procedure Sel is AA date;beginSelect sysdate into AA from dual;dbms_output.put_line(AA);end;变量返回Create or replace procedure Sel (AA out date)isbeginSelect sysdate into AA from dual;end;/set serverout on declare v_aa date; begin sel (v_aa); dbms_output.put_line(v_aa); end;

Answer 2

首先需要设置显示状态：set serveroutput on,然后才可以通过dbms_output.put_line(value);输出，并且value不能单独输出，因为它不是字符类型，需要以'值为：' || value这种方式输出！！！.............

Answer 3

存储过程直接打印
Create or replace procedure Sel
is
AA date;
begin

Select sysdate into AA from dual;

dbms_output.put_line(AA);
end;

变量返回
Create or replace procedure Sel (AA out date)
is
begin
Select sysdate into AA from dual;
end;
/

set serverout on
declare

v_aa date;
begin
sel (v_aa);
dbms_output.put_line(v_aa);
end;

Answer 4

dbms_output.put_line(variable name)

Answer 5

dbms_output.put_line(AA);