Take latest values
The situation is as follows. We have a table with records that are added over time. The request is to produce a resultset that only contains values that are added […]
Cold backup in Oracle
Actually, taking a cold backup in Oracle is quite simple. If you choose to undertake a cold backup by copying tables, it consists of 5 steps. Step 1 is identifying […]
Changing granularity
Let us suppose, we have a table that has a granularity in two dimensions. Think of a customer and a product dimension. So each record has a combination of customer […]
The ORACLE_HOME
Oracle needs to have a set of context variables that allow Oracle to know where the programmes are located. Upon installation, you have to check if these variabled are set. […]
SQL in steps
Let us assume we have a request to show results from a query that is too massive to run on-line. Let us also assume that we may distinguish in this […]
Writing content from Oracle
This note provides a PL/SQL programme that writes the the content of a table to a file. It also uses a steering table (emp_ids) that contains a series of ids […]
Working with XML in Oracle
Oracle has nice features to export data as an XML file. Let us discuss a few of them. The first one is to use SQL Developer. We could already export […]
Data miner in Oracle
I have played a bit with Oracle data miner. This feature is available in the enterprise edition of Oracle version 11 or above. It can be accessed from SQL developer. […]
Adding information
Today, I struggled a bit with a simple situation. I had a table with a primary key and an additional field that was partially filled. I also had a secondary […]
Calculating CPU usage in Oracle
The performance of Oracle is determined by 4 factors: the CPU, internal memory, disk access and network performance. The latter, network performance, is only relevant if data are written or […]