Flashback Query – The SQL statement in distress
Accidentally, important data was deleted. Of course not in a test system but during operation. The pulse and blood pressure rises. But do not worry – it is not always necessary to back up...
Author: Blogofant
SQL Formula (Math Functions)
If you want to calculate a value with a function which is stored in the table (row or column) you can use the follwing code to execute the math formula. Replace placeholders with the...
Autonomous Transactions
PL/SQL normally treads the whole modification as a single transaction. If you want to have some part of the code as seperate transaction, you can use the functionallity of autonomous transactions. The statement PRAGMA...
SQL Aggregation
Aggregation Cube If you have dimensions, you can use the cube function. Imagine you have the dimensions time, state and product. When you use the cube function, you can get an insight of these...
The “Wipfelwanderweg” Rachau
Standing high above and overlook the mountains and pastures of the Mur Valley. No, it is not a new observation tower but you are standing in the woods. With the treetops at your fingertips...
APEX Office Print (AOP) – Problems Excel Text Wrap, Line Break
Problem An Excel template was created (with the variables according to AOP) including line wrapping (text wrap, line break). During the subsequent document creation, however, the line break is not taken into account (not...
Ulm in 3 hours – 180 minutes in Ulm
Ulm at the Danube in 3 hours – that’s why it is worth visiting The university town of Ulm is located next to the border to Bavaria in Baden-Württemberg in Germany. The idyllic Ulm...
Call of Duty Mobile – Tank Battle Tips / tricks / instructions
In the Battle Royal area, Call of Duty Mobile has a new mode for a few days: The Tank Battle as the official name is. The mode can only be played by four people,...
Aruba buses
The bus system in Aruba is well developed and largely corresponds to European and American standards. The buses leave the main terminal on time and go to the respective terminus. Depending on the traffic...
Liquid air batteries as control energy
Solar energy from solar power – so far so good. But at night? Darkness – no electricity. For this reason, there are only two options: storing energy, for example in batteries (keyword balancing energy)...
