Information Technology, Control, Audit and Security Experience

Have you ever wondered how bank account numbers have been created in such a way that no two people can have the same account number? Better still how about Identity numbers like university matriculation number, staff id or Passport numbers. How are they generated without the possibility of a duplication?  This is made possible because of an object that does the tracking called a SEQUENCE.

In this post I will be sharing with you the basics on how to create and manage views on an oracle database. Views are logical tables based on the images of one or more tables in a database. Views form part of the objects created and managed in a schema. A schema is a collection of all objects owned by a particular user views being one of them When a user is created, the schema for the user is automatically created. Let’s now understand how Views are created and managed. Note  This tutorial will be done using SQLPLUS command prompt. Click here to view this tutorial using Oracle LIVE SQL

In this post I will be sharing with you the basics in table management on an oracle database. Tables are the database segments that organize data in the form of rows and columns. A table forms part of the objects created and managed in a schema. What is a schema? A schema is a collection of all objects owned by a particular user which includes tables When a user is created, the schema for the user is automatically created. As this is a new and blank environment, the new user will not have any objects (i.e. tables etc) unless it is created. Let’s now understand how tables are created and managed. Note  This tutorial will be done using SQLPLUS command prompt. Click here to view this tutorial using Oracle LIVE SQL