如何在oracle db中编写参数化查询

-- 创建一个带有绑定变量的查询
SELECT * FROM employees WHERE department_id = :deptId;

-- 在执行查询时绑定参数值
EXECUTE IMMEDIATE 'SELECT * FROM employees WHERE department_id = :deptId' USING 10;

-- 创建一个带有命名绑定变量的查询
SELECT * FROM employees WHERE department_id = :deptId;

-- 在执行查询时绑定参数值
EXECUTE IMMEDIATE 'SELECT * FROM employees WHERE department_id = :deptId' USING deptId => 10;