Tired of using if clauses in PLSQL ? There is an alternative 🙂
All posts under PL/SQL
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.
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[…]
Programming,programming,programming…a way a of life.(kind of!) But how many times do we actually stop to think about what we are doing ? I decided to blog on this, because it is important to always keep in mind some basic concepts Whenever we need to execute a SQL statement, Oracle allocates[…]