Managing DB Objects   «Prev  Next»
Lesson 4Creating a table with Schema Manager
ObjectiveCreate a table using the Schema Manager.
You now know the SQL syntax necessary to create a table.
Oracle ships with a graphical management tool with Oracle 8 and later called the Oracle Enterprise Manager (OEM), enabling you to handle many database management tasks without having to use the character-based command interface of SQL*Plus.
You can use the Schema Manager, which is one of the modules of OEM, to create a table without typing in the SQL syntax. With Schema Manager, all you do is enter the name of the table and the names and datatypes of the columns in the table.
To understand how to use the Schema Manager, step through the following simulation, which demonstrates the steps of creating a small table. The simulation uses OEM on NT as its basic platform. The interface is so simple that you can create a table without worrying about syntax at all.
Creating Table Schema Manager
Using the Schema Manager has two big advantages over entering your own SQL code:
  1. It is easier to use, since the graphical interface acts like a wizard to prompt you for the appropriate values.
  2. Because the Schema Manager always creates valid SQL syntax from the values you enter, you avoid syntax mistakes because of misspelled or missing keywords.
The Schema Manager does not prevent all errors and you can still enter invalid values that result in an invalid SQL statement, but it is still a helpful addition to your tool chest.
The next lesson shows how to ask Oracle for information about the tables in the database.