hi oracle lovers,
i want to know what is bind variable and how does it
improves query performence.
select ename from emp where empno= :num;
now i execute with by giving 7369 and i get the answer.
now i give 7444 ,i get the result ,but how does
oracle make it as soft parse instead of hard parse
while the two queries differ in the semantic structure.
select ename from emp where empno= 7369;
select ename from emp where empno=7444;