Tag Archives: bind variables

What is a Bind Variable in Oracle

Last updated on October 8th, 2019 at 05:47 pmWhat is a Bind Variable? -It is a placeholder for a value .It is replaced by actual value when the SQL statement is executed -In PL/SQL it is called a local or global variable. DECLARE l_empl_id DEPT.emp_id%TYPE; BEGIN select first_name  from DEPT  where id = l_empl_id; END; -in SQL*Plus it is a variable variable a number BEGIN :a … Continue reading What is a Bind Variable in Oracle »