Category: Database

Ad / Advertisement
SQL Developer Commit Rollback 0

Commit and Rollback SQL Developer

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...

Autonomous Transactions, Tune SQL Developer, sql default value if no row is returned 0

SQL Default Value if no row is returned

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...

Autonomous Transactions, Tune SQL Developer, sql default value if no row is returned 0

Autonomous Transactions

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 Transactions, Tune SQL Developer, sql default value if no row is returned 0

SQL Aggregation

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...

Autonomous Transactions, Tune SQL Developer, sql default value if no row is returned 0

SQL Formula (Math Functions)

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...

SQL Flashback Query 0

Flashback Query – The SQL statement in distress

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...