It must be efficient, I’m using bind variables!

For many years, various big guns – and a lot of smaller ones – in the Oracle world have been advocating, nay demanding, that we [almost] always use bind variables in our SQL code. The reason is simple, it’s shareable, efficient,  reduces parsing and allows the application to scale up to more and more users. Continue reading It must be efficient, I’m using bind variables!