by David Schlegl
Write protection can be applied to tables. This prevents DDL (Data Definition Language) and DML (Data Manipulation Language) changes during maintenance mode. The statement: ALTER TABLE tablename READ ONLY; — nur mehr lesbar ALTER...
In principle, Snippet and Code Template serve the same purpose: Previously created code is inserted at the desired location. The only difference between the two tools is the paste option. Snippets require the Snippets...
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...
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...
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...
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...
The SQL Developer sets implicit automatic COMMITs. This COMMIT is subconsciously and automatically canceled in the following situations. Werbung / Advertisements (1) SQL Developer quits normally, with no COMMIT or ROLLBACK statement. In this...
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 Werbung / Advertisements Ajax call got...
What is ITIL 4? ITIL has been a proper name since version 4. However, ITIL used to stand for Information Technology Infrastructure Library. ITIL 4 is largely based on ITIL 3, whereby ITIL 3...
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...
Fallout76 / Games / Technology & Media
The optimal camp location for Fallout 76 – Guide
13. February 2022
Technology & Media / Fallout76 / Games
Fallout 76 – Supplies and Storage Management – Part 1
13. February 2022
