Read and write by Python
tom
Python seems to be a very convenient way to transfer data to and fro Oracle. It has capabilities to set up a connection and it seems quite capable to transfer…
Python in a map reduce environment
I have written a very small python programme that follows the mapper / reducer sequence. This works as a replacement of a more complicated set of Java programmes that might…
Three little handy Oracle statements
I have three little Oracle statements that I us quite often. I realise I use these statements in most programmes I write. But at the same time, I often forget…
Reading XML in Oracle -3
I now have a project where I need to write the content of an XML file into an Oracle table. The idea is actually quite simple. An XML file might…
Bash script to upload file
In many environment, we have a situation whereby a file must be transmitted via a script from one server to another. Assume we have a linux environment where Bash is…
A simple introduction into creating spatial report
I write this to show you how to use Oracle Map Builder and Map Viewer to create spatial reports within Oracle BIEE. I assume you have a set of tables…
How to find a file on Linux
There are zillions of small little Linux commands that make life easy. Those tiny little commands may save you hours of time and tons of frustration. Wheneever I look as…
Dropping a table in Oracle
To drop a table is straightforward in Oracle. One might simply issue a drop table statement. Let us assume we have table HH. When “drop table HH” is fired, the…
R – the shortest name possible
For some reason, short names are popular as computer languages. Think of “C”. Another example is “R”. R reminds me a bit of Matlab; it is an easy to learn…
Hive, SQL on Hadoop
In a previous post, I discussed the difficulty to use Hadoop with its Big Data structure. One must write two different Java programmes. One programme is a so-called mapping programme;…