Tag Archives: What is a Bind Variable

Performance Lesson :What is a Bind Variable

Last updated on July 1st, 2019 at 04:36 amWhat 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 Performance Lesson :What is a Bind Variable »