A bind variable is a variable within a SQL statement that has to be replaced by a valid value on the successful execution of the statement. This value can be referenced into the PL/SQL block. Bind variable is always preceded by a colon (:), as shown in the following code:
Declare
y_emp_age number;
Begin
Select emp-age into :v_empLage from t_employee
where emp_code.121;
End;
In the preceding code, v_emp_age is a bind variable.
