Tired of using if clauses in PLSQL ? There is an alternative 🙂
All posts under Oracle
Using dynamic PLSQL to call functions
A quick how-to to call functions using dynamic PLSQL-
Oracle with clause usage
A simple article explaining the usage of the Oracle With Clause
Java for PLSQL programmers
Java for PLSQL Developers is an overview of Java concepts for PLSQL Developers.
Ten questions every Oracle PLSQL Developer should know
Ten questions that may open your eyes to what’s basic knowledge for a good PLSQL Developer.
Diving into Oracle Analytical Functions part 2/2
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[…]
Diving into Oracle Analytical Functions part 1/2
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[…]
Oracle subquery caching
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[…]
The first Oracle curiosity of 2011 !
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.
SQL performance tip of the day 11g
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[…]