If you’re working with collections you sometimes need to know if some value is a member of it. Fortunately, Oracle provided the very useful member of function, it’s highly optimised and will out-perform other methods Continue reading
Most Oracle developers I know use NVL, rather than COALESCE for returning the first not null value of two arguments. Most will cite it’s for habitual, historic reasons (COALESCE was introduced later in Oracle’s history) or because it’s shorter to type.
“Well NVL and COALESCE do the same thing anyway, so why would I change?“
Well, there’s one very good reason why you should the SQL standards function COALESCE over Oracle’s proprietary NVL….
Adding string data to a CLOB in Oracle can be a tad slow, when compared to other string concatenation situations. I first became aware of this concatenation performance issue from my own coding experience, but also from threads on Oracle Technical Network and a blog post by Jonathan Lewis.
There was recently a post on the Oracle forums by a person who needed to convert decimal values to a binary string. They had found the standard library PL/SQL function that you often see on Oracle sites, but its slow performance was giving him headaches. It was an interesting thread as many people offered solutions, and it showed the ingenuity of people, in coming up with alternatives. In this article I’ll show some of my efforts, and my final function which, to my pleasure, was the fastest in the thread.