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 in every column). However, this also means that when creating a PDF document, the line (in […]
Kategorie Database
12 posts
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, […]
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. First you hvae to finde your installation directory. There you have to edit the following file: “sqldeveloper\ide\bin\ide.conf”. […]
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 AUTONOMOUS_TRANSACTION has to be part of the declarative section. Cause the transaction is seperate you have […]
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 values (you get all possible subtotals). Also a partial cube query is possible. Grouping Rollup – […]
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 values you need. Example Code for a function: Check also the full SQL Guide with lots […]
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 TABLE tablename READ WRITE; -- Read and write possible VIEWs can be equipped with a WITH […]
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 […]
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 window first. This can be dragged to any location in the SQL Developer. In addition, the […]
