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
Airlines Manager is developing into a popular game for smartphones and PCs. However, you can get a lot more out of your smartphone by watching ads. This helps you enormously, especially in the early stages of your airline. This article provides simple Airlines Manager tips and tricks to optimize your airline. These are not only … Read more
One of the best hubs in the game is Hong Kong. Some say it is because of the large number of routes divisible by 24 hours. These are the routes with which an aircraft can be used to full capacity, i.e. all distances which are 24h, 12h, 8h, etc. away. Of course, this also works … Read more
The SQL Developer sets implicit automatic COMMITs. This COMMIT is subconsciously and automatically canceled in the following situations. (1) SQL Developer quits normally, with no COMMIT or ROLLBACK statement. In this case, a COMMIT is sent before the program is terminated. However, this does not happen in the event of a system failure of the … Read more
APEX and Oracle are closely intertwined. For this reason, the APEX also returns Oracle errors. Today I want to tell you how to solve the ORA-20987. Error message Ajax call got server error ORA-20987: APEX – session state protection violation: This error was probably caused because the URL containing a checksum was changed. A link … Read more
This post deals with repairing lawn mowers. What to do if the lawnmower loses oil? What to do if the lawnmower smokes white? The white smoke is a sign that oil has entered the combustion tract. This creates smelly white smoke. Often, this is also paired with the melting of plastic parts of the lawnmower. … Read more
