Stickers - VX Company

Blogs

On business days

When work gets done during business days, that’s what this blog post is about. Moreover, when also the amount of business days is known upfront.

Lees meer

Function call containing out parameters in SQL

You have a procedure or function returning computed values in out parameters. And you’d like to call it in SQL. How’s that done?

Lees meer

Taming outbound call rate

Suppose you are the developer of a database service which can be called any number of times. This database service itself just registers the call, and is allowed to immediately make an outbound call to another service, for example to enhance information presented by the initial inbound call.

Lees meer

Your editor as your primary PL/SQL IDE

How to invoke SQL and/or PL/SQL scripts from Notepad++

Notepad++ might well be your one and only text editor. It’s your favourite editor too, right? But can you run your Oracle SQL*Plus or Oracle PL/SQL commands or scripts from within npp++ at a click of a button ? Yes you can.

Lees meer

Time interval subsequentness

ProblemGreen Leaves In A Row

Given a list of time intervals defining certain detail time validity, how to determine if these intervals are all subsequent to each other ?

Lees meer

Computing overlap between multiple periods of time

ProblemOverlapping_Leaves

This blog post is about a common problem within application programming. It’s about time validity, specifically about multiple periods of time validity and the question of how to compute the overlapping periods. Time validity is always about something, like a contract period, a lease period, or a subscription period. However, I’d like to keep this post abstract in this respect. I’ll assume that periods are ‘grouped’ by a certain foreign referring to the object having the time validity period. Hence, I use column ‘g’ to refer to this fictitious object.

Lees meer

Examine tree-structured data with SQL using connect_by_isleaf

Problem

Leaf

Suppose you have to examine tree-structured data and are interested to know whether or not the current row represents a leaf of the tree. For instance, the data is a representation of geographical district names, which happen to carry different names along time. Typically, the data would be represented by rows including the code and name of the district, a start-date, and end-date and in case the end-date is not null, the code for the district it has been renamed to.

Lees meer