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 available). In addition to the option to go hiking, you can enjoy the legendary delicious home-made flour dinners on the sunny … Read more
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 on beautiful days. From there the well signposted hiking trails begin to the top of the Loser as well as the … Read more
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 introductory film. Directly behind the screen, the tunnel starts deep into the mountain until you reach the salt boundary (the transition … Read more
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 a backup. At least not if the error is noticed early. Crucial for this is the Flashback Query, which is based … Read more
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 values you need. Example Code for a function: Check also the full SQL Guide with lots of useful examples.
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 AUTONOMOUS_TRANSACTION has to be part of the declarative section. Cause the transaction is seperate you have to seperate specify a COMMIT … Read more
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 values (you get all possible subtotals). Also a partial cube query is possible. Grouping Rollup – SQL Aggregation The rollup clause … Read more
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 and this spectacular panoramic trumps the Wipfelwanderweg Rachau. The access Starting point is the cards building with a souvenir shop and … Read more
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 in every column). However, this also means that when creating a PDF document, the line (in the respective column) is cut … Read more
Bucharest is the capital of Romania and the economic and political center of the country. Outside of Romania, the capital of Romania is not exactly known for the multitude of sights and tourist attractions. For this reason, the capital is not on the TOP 10 list of capitals that travelers in Europe definitely want to … Read more
