by David Schlegl
The SQL Developer sets implicit automatic COMMITs. This COMMIT is subconsciously and automatically canceled in the following situations. Ad / Advertisement (1) SQL Developer quits normally, with no COMMIT or ROLLBACK statement. In this...
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...
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, the line break is not taken into account (not...
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...
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. Ad...
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...
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...
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...
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 – it is not always necessary to back up...
