The ORACLE_HOME
tom
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…
Backing up in Oracle via data pump
Oracle has several possibilities to back up the data. One possibility is backing up via data pump. This facility can be used by the command line. Let us discuss three…
Oracle only listens to localhost
It happens to me quite often. I install Oracle and it only listens to the localhost. In a few steps, one can get it to listen to the IP address…
Encryption in Oracle
Oracle has a nice facility to store data in an encrypted form. This allows to hide data content from users while still allowing them to see the columns. If one…