What actually happens when you run a SQL query that doesn’t return any rows? For example, think of a WHERE clause with the condition 1=2,…
Your SQL Developer is behaving slowly when starting and executing queries? Then I have the right tips for you here. Two blog articles already deal…
Is your SQL developer slow? Then here are a few tips and tricks to make it a little faster. Note that you use the Always…
NVL and NVL2 are Oracle specific and where introduced before the ANSI-92 standard (which includes COALESCE) was created. NVL and COALESCE are nearly identical, even…
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…
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…
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…
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…
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,…
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…