5.6.txt

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

DECLARE
      v_sal number(6,2);
    BEGIN
       SELECT sal INTO v_sal FROM employee WHERE
 employeename=trim('&&name');
    IF v_sal<2000 THEN
      UPDATE employee SET sal=v_sal+200 
      WHERE  employeename=trim('&name');
    END IF;
END;