Setup & Run PGBENCH
As I am “playing” a bit with PostgreSQL databases it is worth to looking at the underlying platform and measure performance. There is
Kategorie: sql
Cloning Schema with Data Pump
Here is one quick example how to clone one schema within a Oracle database. The most easiest way is to use data pump. My hint will have also the
Merge Statement and Sequences
In my last project I had to create a merge statement which should insert or update rows in dependency of the source data. The behavior of the
Get latest data record
Sometimes I have a request to search within a table find out for example when a server delivered his data last time. Here some sample data. As
