在Oracle SQL中使用变量

DECLARE
  v_salary NUMBER;
BEGIN
  -- Your PL/SQL code goes here
END;
/

v_salary := 1000;

DBMS_OUTPUT.PUT_LINE('Salary: ' || v_salary);

DECLARE
  v_employee_id NUMBER := 100;
  v_first_name VARCHAR2(50);
  v_last_name VARCHAR2(50);
  v_salary NUMBER;
BEGIN
  -- 查询员工信息并存储到变量中
  SELECT first_name, last_name, salary
  INTO v_first_name, v_last_name, v_salary
  FROM employees
  WHERE employee_id = v_employee_id;

  -- 输出员工信息
  DBMS_OUTPUT.PUT_LINE('Employee ID: ' || v_employee_id);
  DBMS_OUTPUT.PUT_LINE('First Name: ' || v_first_name);
  DBMS_OUTPUT.PUT_LINE('Last Name: ' || v_last_name);
  DBMS_OUTPUT.PUT_LINE('Salary: ' || v_salary);
END;
/

SELECT *
FROM employees
WHERE salary > :v_salary;