PLSQL Procudure (Oracle) 比较 where 子句中的变量

介绍PL/SQL存储过程中的变量比较

sql
CREATE OR REPLACE PROCEDURE GetEmployeesByDateRange (
    p_start_date IN DATE,
    p_end_date IN DATE
)
IS
BEGIN
    SELECT employee_name, hire_date
    FROM employees
    WHERE hire_date BETWEEN p_start_date AND p_end_date;
END;
/

sql
CREATE OR REPLACE PROCEDURE GetEmployeeByName (
    p_employee_name IN VARCHAR2
)
IS
BEGIN
    SELECT employee_id, employee_name
    FROM employees
    WHERE employee_name = p_employee_name;
END;
/

sql
CREATE OR REPLACE PROCEDURE GetEmployeesBySalary (
    p_salary_limit IN NUMBER
)
IS
BEGIN
    SELECT employee_name, salary
    FROM employees
    WHERE salary > p_salary_limit;
END;
/