Category: Database

Werbung / Advertisements
SQL 0

SQL Developer Memory Settings

Werbung / Advertisements 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 with the optimization of SQL Developer....

SQL 1

SQL Developer Slow

Werbung / Advertisements 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 optimize SQL Developerand you should also...

Werbung / Advertisements
Werbung / Advertisements
SQL

SQL Formula (Math Functions)

Werbung / Advertisements 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...

SQL

Autonomous Transactions

Werbung / Advertisements 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....

Werbung / Advertisements
SQL

SQL Aggregation

Aggregation Cube Werbung / Advertisements 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...

Schreibschutz von Tabellen 1

Write protection of tables

Werbung / Advertisements 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...

Werbung / Advertisements