5.21.txt

来自「delphi renyuanguanlixinxioxitong」· 文本 代码 · 共 10 行

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;