作者:上床后悔_155 | 来源:互联网 | 2023-05-17 08:57
开始在sqlworksheet中,执行一个block之前,执行setserveroutputon;setserveroutputon;declareg_salarynumber:1
开始
在 sql worksheet 中,执行一个 block 之前,执行 set serveroutput on;
set serveroutput on;
declare g_salary number:=100;
begin
select salary into g_salary from employees where employee_id=178;
dbms_output.put_line('the salary is:'|| g_salary);
end;
script out 窗口中输出:
anonymous block completed
the salary is:7000
结束