How to connect to SQL Plus in oracle database

Here, I am going to show you how to use sql plus to tap into your database n oracle database. Sql plus is one the user interface in oracle database which also include enterprise manager. One advantage of Sql plus is that it corresponds with every version of oracle database.

Read More

How to create tables in oracle database using enterprise manager

The last post was on how to create tables in oracle database using sql plus platform. Today we’ll create a table using another platform which enterprise Manger.

Creating a table using enterprise manager seems to be a lot easier than writing the sql codes. Another advantage of using enterprise manager is that after creating tables you can still get the sql codes if you wish to learn it.

First log in to your database using enterprise manager. Remember that enterprise manager is a web based platform use to manager oracle database administration.

From the home page of the enterprise manager select schema as you can see encircled in red

Read More

Datatypes used in oracle database administration

Datatypes are the structural or the physical attributes of a table. I would say that the kind of table you create is determine by the data you are bringing into the table.  Datatypes helps determine the kind of data entered into a table. For example Column for phone numbers will not have the same kind of dataype with column for names.

Types of Datatypes

In oracle database, there a lot of datatypes used but I am going to filter it to the most commonly used in your day to day tasks as an administrator in creating your schema objects.

Here they are

Read More

How to create a table in oracle database administration using sql plus

Like i said in earlier post oracle database is relational database with markup and extensive language (xml). Data is stored in two dimensional tables consisting of rows and columns. oracle database enables you to store, update and efficiently retrieve it with high degree of performance and reliability.
Every thing is tables. having a database means having a pools of tables containing information that are related. Linked together keys and constraints, like foreign keys and primary keys.

Read More

How to Create a database using oracle database configuration assistant (ODCA)

Ordinarily oracle universal installer (OUI) automatically runs oracle database configuration assistant (ODBCA) during installation unless otherwise stated that only software should be installed.

Note that when you create a new database, the new database typically use the same oracle home directory as the first database but stores database data-files separately from the first one.

Read More

How to Install Oracle 11g Software

During Installation; you are given the option or opportunity to to create a database. If u wish to the OUI (oracle universal installer) automatically starts oracle database configuration assistant (ODCA) to guide you through the process of creating a database.

Before installation process; you must

Read More

ROLES OF AN ORACLE DATABASE ADMINISTRATOR

Oracle database is relational database with markup and extensive language (xml). Data is stored in two dimensional tables consisting of rows and columns. oracle database enables you to store, update and efficiently retrieve it with high degree of performance and reliability. In case you are wondering why I chose to write on oracle database. This is one the many reasons why Database administration is best with oracle database. If you have not read my post, you can take a glance here. I chose it also because its where I specialize.

Read More