I'm starting to work with Oracle DB, and I'm demanded to use bind variables in my app. Can someone give some brief directions what's bind variables advantage and when should i use them ?
Thanks!
The big advantage of using bind variables is that you can write a full statement that Oracle can pre-compile already. In other words it doesn't need to re-parse the statement again just because you're looking for value 1 instead of 100. A bind variable more or less is a place-holder.