This article explains how we can unlock a user account in an Oracle database. As a database administrator, managing the security of the database is a crucial task. The DBAs must keep track of all succ...
This article explains what DDL scripts are and how to use them. The script can contain various PL/SQL DDL commands used to create database objects and establish the relations between them. The abbrevi...
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...
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 the fundamental concepts of a primary key vs foreign key, and also explains the difference between a primary key vs foreign key. What is a Primary Key The primary key is one col...
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...
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...
