SQL> variable v_dept number
SQL> exec :v_dept := 10
SQL> select * from employees where department_id = :v_dept;
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL ...
--------------- -------------------- ------------------------- ----------- ...
200 Jennifer Whalen JWHALEN ...
SQL> exec :v_dept := 10
SQL> select * from employees where department_id = :v_dept;
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL ...
--------------- -------------------- ------------------------- ----------- ...
200 Jennifer Whalen JWHALEN ...