5.21.txt

delphi renyuanguanlixinxioxitong

DECLARE
  v_ename employee.employeename%TYPE;
BEGIN
  SELECT employeename INTO v_ename FROM employee WHERE employeeno=&no;
  dbms_output.put_line('员工名：'||v_ename);
exception
  WHEN NO_DATA_FOUND THEN
    dbms_output.put_line('员工号不正确，请核实员工号！');
END;