Posts from category: PL/SQL

25

05.2014

PL/SQL performance freak series – function calls from SQL overhead

In my previous post I’ve shown and measured the performance loss on passing the parameters to and from procedure/function call inside PL/SQL code. In this article I’m about to reveal another bottleneck that is often forgotten and not so easy to overcome. Suppose you need to have some value calculated. The formula is straight matematical calculation but the […]

read more

18

05.2014

PL/SQL performance freak series – function/procedure parameters overhead

When writing a PL/SQL code, I usually use following strategy: If the code that I’m calling is returning a calculated value, it should be a function. If the code that I’m calling is doing some DB operations and is not returning a value, it should be a procedure. There are however some situations, when I tend to […]

read more

24

01.2014

How I started to create Unit Tests for Oracle PL/SQL code

Before I started working at Pragmatists I never actually took time or effort to research the web for automating the testing process in Oracle databases. My previous job was more about delivering solutions, advisory, analysis, design and implementation using the traditional cascade product delivery approach. I don’t want to get into too many details on how it […]

read more