Improve the Performance using Bind Variable in Oracle

What 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 …

Improve the Performance using Bind Variable in Oracle Read More »