It is possible to trap errors in the loading process. This is handy when we work on a migration project. We simply load a table and trap all possible errors. […]

Oracle has a use that may act as an example user with a series of tables. This example can be used to get acquainted with oracle SQL or data modelling […]

Encrypting in Python can be very easy. Below, a snippet is provided that allows to encrypt data. The code can be found here : However, as the code is simple, […]

I am quite impressed with Azure SQL Server. The DBMS is easy to understand as will be shown below. The problem is how to add data from a local file […]

Below, I provide a snippet to read data from an Azure SQL Server database. Subsequently, it is written to another table in the same database. The trick here is to […]

Below, you find a nice example of an hierarchical query in Oracle. The idea is that you see the top-down hierarchy with some indications on the level that is shown. […]

What is the size of an Oracle table? A very rough approximation is to multiply the number of rows with the average row length in bytes. Fortunately, Oracle directly provide […]

Oracle has a nice possibility to calculate running totals. Assume we have a sales system where transactions are stored over time. We would like to know the running total – […]

Once, I wrote a completely useless programme – see below. I like to retain it as I spent quite some time on it. But it is absolutely useless. The idea […]

Oracle has 3 analytical functions to rank data. They provide approximately the same results, but with little deviations. First the code: select salary, rank() over (order by salary) rank, dense_rank() […]