SQL 语法中冒号 ('') 的含义是什么 [复制]

# SQL语法中冒号(':')的含义及案例

sql
-- 创建一个包含参数绑定的查询
SELECT * FROM employees WHERE department_id = :dept_id;

sql
-- 根据条件动态选择查询
DECLARE
    v_department_id NUMBER := 100;
    v_salary_threshold NUMBER := 50000;
BEGIN
    EXECUTE IMMEDIATE 'SELECT * FROM employees WHERE department_id = :dept_id AND salary > :salary'
    USING v_department_id, v_salary_threshold;
END;