Author Archives: Jens Marre

quantum computers – the quantum revolution begins

Quantum computers have the potential to change our society in a similar seminal way, that conventional computers have done up to this day. What started 30 years ago as a visionary legacy of an ingenious physicist is becoming real in … Continue reading

Posted in Uncategorized | Leave a comment

Set the value of a popup lov dynamically in Oracle APEX

Dynamic Actions are a great tool in Oracle APEX and you can use them very easily in an declarative way. Yet, to set the value of a popup lov dynamically, it is easier to render the link with the java … Continue reading

Posted in Apex, Oracle | Leave a comment

A generic data model for organigrams

During my work as an IT consultant I have also implemented systems for resource planing for many years (both objects and human resources). Based on this know-how I and my colleague have generated a generic data model for organigrams which … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Sending a tabular HTML report via APEX Mail

While operating a Oracle APEX application it is often necessary to send tabular SQL reports via mail. This may be an administration mail about the status of the APEX application or for  reporting data to users or stakeholder of the … Continue reading

Posted in Apex, CSS, Mail | Leave a comment

How to generate history tables in Oracle SQL

By enabling Oracle Flashback you have an excellent option to report and search for historical data in your Oracle tables. Yet even this option might prove to be insufficient for certain requirements or situations. E.g. if Flashback is not enabled … Continue reading

Posted in Oracle, PL/SQL | Leave a comment

Big Bang, dark energy, multiverses and all that

Having studied theoretical physics and math one of my passions is to keep up with later developments in this kind of science. Sometimes I listen to a podcast lecture series on my way to work. Recently I stumbled upon the … Continue reading

Posted in Physics | Tagged , | Leave a comment

Flexible Resource-Gantt-Chart with Oracle Apex and AnyChart / AnyGantt (2)

The standard charting features in Oracle Apex provide an easy and fast way to create various simple charts. After you collect more and more requirements, you will soon get to the limits of the Apex-Wizards. Yet, the Oracle Apex environment … Continue reading

Posted in Uncategorized | Leave a comment