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

In today's blog post we will be looking at how data is arraigned and stored in the database.  An Improperly o rganized   data could reduce the database integrity or negatively impact on its performance.  This arrangement can be likened to an organogram (Organisations hierarchy structure)  where we have segmentation like: - Groups - Departments - Units - Teams - Staff (this being the smallest unit) Now that the concept is clear let us get busy.....

“The Captain of a plane that knows nothing about the mechanical parts of his plane would eventually crash it one day.” I believe it would be nice to introduce you to the inner workings of the Oracle database. This would be useful to the intending DBA, audit or control officer and finally the ordinary enthusiast. You cannot effectively manage the oracle database if you don’t know how it processes data and presents information to you. So let’s get busy………

Lets learn a little on how to interact with a database using a language called SQL . If you are already familiar with SQL, then this post is NOT for you. This blog post is tailored for beginners with interest in the query language. SQL means S tructured Q uery L anguage. Simply put, it is used to communicate with a database in order to define, access, or manipulate it's data.

Have you always desired to test on the fly, a script you just thought up to see if it would work? If you are that someone like me then you are in luck as Oracle Corporation has designed something for us (those guys think of everything). Ladies and Gentlemen, I introduce to you ORACLE LIVE SQL. Disclaimer: Please note that I am in no way affiliated to Oracle nor was I paid to spin this hype.😀