Bratislava in 24 hours – 1 day in Bratislava Bratislava is the capital of Slovakia and the economic center of the country. Outside of Slovakia, the capital of Slovakia is not known for a variety of sights. It is therefore not on the TOP 10 list of capitals, which travelers […]
Sometimes default values are necassary. Normally you can use NVL or NVL2 when you get NULL values as return value. But it is also possible, that no row is returned. In this case, NVL or NVL2 is not working, cause you get no value back – not even NULL. Therefore, […]
Oracle SQL Developer is slow and you want to tune SQL Developer? Or too slow for you? Then you should tune your Developer Tool. It is really easy and everyone can do it. Werbung / Advertisements First you hvae to finde your installation directory. There you have to edit 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 AUTONOMOUS_TRANSACTION has to be part of the declarative section. Cause the transaction is seperate you have […]
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 – […]
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. Werbung / Advertisements Example Code for a function: Check also the full SQL […]
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 Werbung / Advertisements Starting point is […]
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 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 […]
