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...
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...
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). ...
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...
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...
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 ...
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...
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...
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...
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...
I was having a hard time trying to connect to one of my test databases. It took a lot of trial and error until I realized it was because I was using an Oracle 19c client to connect to an Oracle 11g da...
Are you trying to figure out how to load data from Excel into your database? The problem: load data to Oracle Many business analysts rely heavily upon Microsoft Excel as one of their primary sources ...
