by David Schlegl
NVL and NVL2 are Oracle specific and where introduced before the ANSI-92 standard (which includes COALESCE) was created. NVL and COALESCE are nearly identical, even there are some differenced I would like to point...
Happy birthday in English Happy birthday means “ Happy Birthday ” in English. This designation is the most formal and most frequently used in German-speaking countries. So if you are wishing someone a “Happy...
Happy birthday in Austrian Happy birthday in Austrian language means “Alles Gute zum Geburtstag” . This designation is the most formal and most frequently used in the German-speaking world. So if you wish someone...
Happy birthday in German Happy birthday in German means “Alles Gute zum Geburtstag” . This designation is the most formal and most frequently used in the German-speaking world. So if you wish someone a...
The Blaa Alm On the way to Loser you can turn left to Blaa Alm. After a short drive on dirt road, you finally reach the alpine pasture (there are plenty of parking spaces...
The Loser-Panorama-Road The nine kilometer long toll road to the Loser offers a spectacular panorama of the surrounding landscapes and mountains. Parking spaces are available at the 1600m Loser-Alm – but they are rare...
Become a miner The Salzwelten Altaussee is a special experience for young and old! Explore the world of the miner by putting on the white miner’s ridge. Afterwards you get entertained with a short cabaretistic...
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...
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...
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...
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...
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...
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 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...
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,...
NVL and NVL2 are Oracle specific and where introduced before the ANSI-92 standard (which includes COALESCE) was created. NVL and COALESCE are nearly identical, even there are some differenced I would like to point...
Happy birthday in English Happy birthday means “ Happy Birthday ” in English. This designation is the most formal and most frequently used in German-speaking countries. So if you are wishing someone a “Happy...
Happy birthday in Austrian Happy birthday in Austrian language means “Alles Gute zum Geburtstag” . This designation is the most formal and most frequently used in the German-speaking world. So if you wish someone...
Happy birthday in German Happy birthday in German means “Alles Gute zum Geburtstag” . This designation is the most formal and most frequently used in the German-speaking world. So if you wish someone a...
The Blaa Alm On the way to Loser you can turn left to Blaa Alm. After a short drive on dirt road, you finally reach the alpine pasture (there are plenty of parking spaces...
The Loser-Panorama-Road The nine kilometer long toll road to the Loser offers a spectacular panorama of the surrounding landscapes and mountains. Parking spaces are available at the 1600m Loser-Alm – but they are rare...
Become a miner The Salzwelten Altaussee is a special experience for young and old! Explore the world of the miner by putting on the white miner’s ridge. Afterwards you get entertained with a short cabaretistic...
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...
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...
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...