Most Popular Application design

Tips for Custom Application Monitoring

Custom applications play a vital role in all kinds of organizations, including education, government, healthcare, IT, and more. In order to adapt to the latest technologies, there are many changes businesses must make, especially the method they use to reach out to their customers.   Most interactions between the customer/client and the organization takes place via […]

Read More

A Warning About Automatic Conversions in Oracle 12c

The issue of whether allowing SQL to do automatic conversion of datatypes is a good practice or not has arguments on either side. On one hand, this practice considerably simplifies and reduces the functions necessary to make a SELECT statement work. On the other hand, if your assumption about what will be in the column […]

Read More

NULLs in Group-Value Functions in Oracle 12c

Group-value functions in Oracle treat NULL values differently than single-value functions do. Group functions (other than COUNT(*)) ignore NULL values and calculate a result without considering them. Take AVG as an example. Suppose you have a list of 100 friends and their ages. If you picked 20 of them at random and averaged their ages, […]

Read More

10 Commandments for Oracle Database Application Design

It is worthwhile to sum up in a single place all the major issues in designing Oracle database applications—thus “The Commandments” (or perhaps “The Suggestions”). Their presentation does not assume that you need to be told what to do, but rather that you are capable of making rational judgments and can benefit from the experience […]

Read More