A quick how-to to call functions using dynamic PLSQL-
All posts under SQL
A simple article explaining the usage of the Oracle With Clause
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[…]
Hi all! One of the most used database concept is hierarchies. Why? Basically, any relation that can be categorized as a “Father” – “Son” relationship can take advantage of this concept. Lets us imagine you want to represent the relationship between an employer and an employee. You could probably create two[…]
Hi all ! One of the biggest hassles I had a couple of months ago was how to find dependencies between Oracle objects. As always, after some internet browsing I found out that there was something to help us! Before I go into further details let me just briefly explain[…]