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