Oracle Aggregate and analytic functions
tom
We all know aggregate functions in Oracle. Let me provide a simple example to recap what the aggregate function is. Let us firse this SQL on a 107 record table:…
Inserting a BLOB
Inserting a BLOB in Oracle is slightly different from inserting from inserting a value in an Oracle database. We first have to create a location with n empty BLOB. After…
Oracle numerical data
Numbers can be stored in Oracle according to different formats. On one hand, we have the American way, whereby numbers are stored with a dot (.) as decimal indicator. On…
Copying data with data pump
Oracle has a brilliant feature to export / import data at great speed. The trick is to use the data pump facility. Let us first introduce the export via data…
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…
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…
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…