Why and How to kill a session in Oracle
If you are a Database Administrator (DBA), indeed, you have encountered the situation of needing to kill a session in the Oracle database. Many different situations can lead you to need to kill a ses...
How to alter a table in Oracle
This article explains how to use the ALTER TABLE statement to modify the oracle table. We are going to use an array of examples in order to learn how to alter a table in Oracle. We can perform the f...
Three different ways to determine Oracle database size
This article explains the different ways to determine Oracle database size. We are going to learn about the following topics: Populate the size using catalog views Populate the size of all pluggable...
How to add a column to table in Oracle Database
This article explains how to add a column to table in an Oracle database. After creating a database table, it may be needed to add additional columns as the table design evolves based on data requirem...
Unit Testing Best Practices with Toad for Oracle
Unit Testing Best Practices with Toad for Oracle
In this article we’ll discuss some of the best practices of unit testing. What is unit testing? Unit testing in Toad for Oracle is used to test PL/SQL objects (functions, procedures and packages). ...
How to Create an Oracle Database Sequence: Explained with Examples
How to Create an Oracle Database Sequence: Explained with Examples
It is often necessary to assign integer column values that are in sequence across different rows of data in a relational database. Oracle Database provides Oracle Sequence for creating a sequence of i...
An Overview of the NVL and NVL2 function with examples
An Overview of the NVL and NVL2 function with examples
Preparing data for analysis often means encountering some shortcomings within the data itself. Extra spaces, null values, blank values, wrong data types and duplicate values all stand in the way of pr...
Fixing the “not a valid month” Oracle database error
Fixing the “not a valid month” Oracle database error
If you use the DATEdata type in your SQL code, it is likely that you have come across the “not a valid month” Oracle database error. As we shall discuss, the error can be fixed with a slight tweak of ...
Getting started with Oracle 18c Express edition
Getting started with Oracle 18c Express edition
Introduction to Oracle 18c Express edition (XE) Oracle 18c Express edition (XE) is a lightweight database that can be used to host small applications and is often used by students or developers to tes...
Dark mode has arrived for Toad for Oracle 15.1
Dark mode has arrived for Toad for Oracle 15.1
Remember the old days of original “dark mode?” I do. When I was in my second year at university, I was delighted to receive a personal computer XT as a gift. It was a wonderful gift because it allowed...
SQL performance tuning and optimization using SQL Optimizer
SQL performance tuning and optimization using SQL Optimizer
No database can process all queries expediently, but we can strive to make sure our databases process SQL as efficiently as possible. That means applying SQL performance tuning and optimization to our...
Learn what distinguishes Toad for Oracle vs Toad Data Point
Learn what distinguishes Toad for Oracle vs Toad Data Point
Quest® Toad® for Oracle and Toad Data Point offer powerful sets of features. However, it is essential to understand when it is most appropriate to use one tool over the other. When choosing between To...