Category: Education

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

Drop generator

Drop generator as a new renewable energy source

Alternative renewable energy – a term that has been branded in recent years. The key words here are a lot of wind, sun, water, geothermal energy and biomass. Today it is about a new...

Liquid Air Batteries

Liquid air batteries as control energy

Solar energy from solar power – so far so good. But at night? Darkness – no electricity. For this reason, there are only two options: storing energy, for example in batteries (keyword balancing energy)...

0

APEX Background Color for Button

Button Id First you have to set a static id for the button. Mark the button >> properties >> Advanced >> Static Id: btnX Ad / Advertisement You can choose any value for your...

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