declare
v_ename emp.ename%type;
v_deptno dept.deptno%type;
v_dept_row dept%rowtype;
begin
select ename,deptno into v_ename,v_deptno from emp where empno=&no;
select * into v_dept_row from dept where deptno=v_deptno;
dbms_output.put_line('您要找的员工是:'||v_ename||',所在部门信息为:');
dbms_output.put_line('部门编号:'||v_deptno||' 部门名称: '||v_dept_row.dname|| '所在地:'||v_dept_row.loc);
end;
/
------解决方案--------------------
SQLPLUS 下面执行 set serverout on;
DEVELOPER看输出页面.