Estimating with Python
tom
It is relatively easy to do an estimate with a Python script. This is due to the fact that Python works with matrices and such matrices can be used as…
Read and write by Python
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…
Connect from 32 bit environment to 64 Oracle instance
One may retrieve the version of Oracle with a simple command: “select * from v$version;”. One may then see that the Oracle instance is a 64 bit version. In my…
Create a report with BI Publisher
One could create reports within the OBIEE sphere with the analytics. Another possibility is to use the BI Publisher. This option has several advantages. One advantage is that one choose…
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…
Reading XML in Oracle -2
Loading XML into Oracle might require some SQLLDR code. Of course, the standard insert is a possibility, but this might be slow if many XML files are to be loaded.…
Reading XML in Oracle -1
As a first example on how to read an XML file, I show how an XML file can be read with a PLSQL programme. The logic is quite simple. We…