Finding errors in Oracle
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.…
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 –…