Tired of using if clauses in PLSQL ? There is an alternative 🙂
All posts under Oracle
A quick how-to to call functions using dynamic PLSQL-
A simple article explaining the usage of the Oracle With Clause
Java for PLSQL Developers is an overview of Java concepts for PLSQL Developers.
Ten questions that may open your eyes to what’s basic knowledge for a good PLSQL Developer.
Hello all and welcome back for the second part of this post ! As promised, on the previous post , I will cover RANK function, DENSE RANK and ROW_NUMBER analytical functions. RANK The rank function allows us to rank a value in a group of values.The Oracle rank function comes in[…]
Hi all ! A couple of weeks ago I felt the need to research a little further on Oracle Analytical Functions. They are so powerfull, yet, only a couple of PLSQL programmer friends were into them. Before beginning this post, let me just make a brief intro. There are 6 types[…]
On Oracle there’s a kind of cache that works with scalar subqueries (look below for a simple example of a scalar subquery) which prevents the database engine to repeat unnecessary work to get the same result again and again. But while this seems to be less than useful with pure Oracle[…]
Ever wondered why some subqueries have odd behaviours ? Then this small post is for you. We just use some very pratical examples to show to use cartesian joins between subqueries carefully.
Hi all ! After all the big changes we’re now fully back to our posts ! Today’s post will focus on an SQL performance tip. A couple of days ago I just came across with a performance problem regarding a join between a table and a collection. Apparently the Oracle[…]