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...

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....

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 key...

Read More