我的绑定变量var_dep不会在屏幕上打印任何内容。其他内容都正常打印。它只打印";出发:"。
我的代码是:
SET serveroutput ON;
SET echo OFF;
VARIABLE var_dep varchar2(20);
DECLARE
v_numar number(3);
BEGIN
select department_name, count(*)
into :var_dep, v_numar
from employees e, departments d
where e.department_id = d.department_id
group by department_name
having count(*) = (select max(count(*))
from employees
group by department_id);
dbms_output.put_line('Departament: ' || :var_dep);
dbms_output.put_line('Nr Angajati: ' || v_numar);
END;
/
欢迎,";打印";命令/关键字用于通过sqlplus/oracle显示绑定变量,就像0xdb所说的那样。现代IDE的行为可能因底层sql版本的不同而有所不同。