Oracle database management, tutorials, scripts, coding, programming and tips for database administrators
It is believed that count(*) expands to all columns and that count(rowid) is faster. Read on to see why the opposite might be true.
Learn about the concept of views in SQL, and how they work. Read on to see clear examples of how to implement views.
In Oracle 12.2 and later a group-by elimination enhancement can produce wrong results. Read on to see what can be returned and how to work around it.
The latest two versions of Oracle can throw an error when columns are set as unused and then dropped. Learn about this issue and how to address it.
Database tables are not static entities and sometimes changes can wreak havoc on packages and procedures. Read on to see how Oracle's expand_sql_text can help solve such issues.
Learn of possible scenarios to monitor changes when replicating Oracle. Read on to discover the best course of action for moving forward!
If you are wanting to manipulate numeric data with mathematically, then you will wan tot read on to get an overview of the core SQL numeric functions