5.49.txt

delphi renyuanguanlixinxioxitong

DECLARE
 sql_stat VARCHAR2(100);
BEGIN
 sql_stat:='UPDATE employee SET sal=sal+sal*0.5 WHERE departmentno='||''''||'003'||'''';
 EXECUTE IMMEDIATE sql_stat;
END;