ODI has a feature that allows to read XML data. I really enjoyed working with this feature. It allowed to directly insert values from an XML file into different fields […]

Oracle has a very nice ETL tool (or in Oracle parlance ELT tool). Its purpose is clear: make a easily maintainable set of workflows that show clearly the lineage from […]

Oracl has a nice feature to add a rank to a row. Let us assume you have a table with 4 values: some rows have an A, others have a […]

The idea is actually quite simple. Whenever a record in a table (here: employee) is updated with a new value in a field (here: salary), a trigger gets fired. This […]

This note provides an example on a trigger. I like this example as it shows how additional business logic can be implemented. It is an example of a statement trigger: […]

Oracle has a package that allows you to write to a file. Oracle uses the concept of a directory (here “External”) that acts as a logical description of a directory. […]

This programme shows you we may retrieve the results from a query. It works with a cursor that contains another cursor. The example below is a cursor that retrieves data […]

This programme contains a package along with a calling programma that uses this package. Let me first provide the package itself. The code: CREATE OR REPLACE PACKAGE employee_data AS TYPE […]

The idea is as follows. We want to create a simple function that calculates a code from a string. This code is the total ASCII value of the characters in […]

This programme uses PLSQL to select a set of 1000 records per item. Each item is calculated from a cursor that generates the items for which a set of records […]