练习：在USING子句中未初始化的变量表示NULL

(11g12_07_03.sql, 11g12_07_03.tst)

-- 11g12_07_03.sql

CREATE TABLE EmployeeTemp AS SELECT * FROM EMPLOYEES;

-- 1执行11g12_07_03.tst前查看EmployeeTemp

SELECT * FROM EmployeeTemp;

-- 执行11g12_07_03.tst

-- 1

-- 11g12_07_03.tst

DECLARE

-- 在运行时自动设置为NULL

aNULL CHAR(1);

BEGIN

EXECUTE IMMEDIATE 'UPDATE EmployeeTemp SET commission_pct = :x'

USING aNULL;

COMMIT;

END;

ITPub博客

PLSQL Language Referenc-PL/SQL动态SQL-练习：在USING子句中未初始化的变量表示NULL