Whoever joins the game often has one thought first: start the game from your home airport. The first hub – it should be the nearest airport that you know. But that’s exactly what you shouldn’t do most of the time. Regional airports are usually smaller, have a low category and a low demand for freight … Read more
Symi is only 58 square kilometers in size, but is becoming increasingly popular with tourists. The still relatively undiscovered island has no airport and is therefore only accessible from Kos or Rhodes reachable by boat (ferry or excursion boat). The island of Symi at a glance Symi is located about one to two hours by … Read more
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 want to see. Nevertheless, you … Read more
Sun, beach and sea – Aruba has it all. The ABC island of Aruba is one of the Dutch overseas territories. The island off the coast of Venezuela offers wonderful white beaches with little to moderate waves. The capital of the Caribbean island is Oranjestad. Aruba has an area of almost 180 square kilometers and … Read more
SQL IN list SQL IN Statement (IN lists) can only process and validate 1000 values. Everything about it returns an error. Here’s an example to demonstrate an IN list. Here only employees and workers are shown, which identification number is in the IN list. SELECT * FROM emp WHERE 1=1 AND empNo IN (1, 2, … Read more
What is the Grazer Altstadt Bim? What is the Grazer Old Town Tram? With the Old Town Bim tourists and locals drive free through the city center of Graz. This free ride is valid on all tram lines as well as the rail replacement during the whole week. It should be noted that the old … Read more
This article discusses operational optimization problems and algorithms. Additionally, graphs, paths, and cycles are revisited, and complexity is discussed. The algorithms section delves into heuristics and approximation algorithms, primarily focusing on the Travelling Salesman Problem and the Knapsack Problem. The emphasis here is on generating a valid tour or a valid composition of the problem. … Read more
NVL VS NVL2 The difference between the SQL functions NVL and NVL2 is, that when using the function NVL2 you can set different values for NULL and NOT NULL. NVL only checks and analyzes the first expression. If the expression is NOT NULL, the function outputs the value of the field. If a NULL value … Read more
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, there are some options – … Read more
