Oracle package
tom
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…
Generate code in Oracle
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…
Handy PLSQL programme
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…
Giving values to primary key
Let us see how we might provide a value to the primary key in Oracle. There are many ways to provide a value for the primary key. One is to…
PL SQL that creates a table
The situation is simple. We have to create a table that contain data on a certain variable outcome. Normally, one would like to create a field in the table and…
Hot backup in Oracle
It is possible to make a hot backup in Oracle. This implies that we do not have to shutdown the database before creating a backup. The steps are as follows:…
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…
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…
External tables in Oracle
External tables allow someone to store data in a file while these files are shown as tables within Oracle. So, we have a two sided object – on one hand…