HomeOracle Page 3 - Creating a Table using Oracle 10G XE
Creating a table using the Wizard - Oracle
Oracle 10G XE provides a wizard to help you create a table. The wizard walks you through several steps for creating a table, taking you to the next step after you have entered valid entries for the current step. While scripts can be used to create a table, creating a table using the visual, form-based creation process is a lot simpler and less prone to errors. This tutorial describes a table to be created in the HR database with all the necessary ingredients for a typical database.
From Start -->AllPrograms-->Oracle 10g XE Express Edition, open up the login page by clicking on Go to database Home Page. This opens up the login web page shown in the next picture.
Click on the arrow on the Object Browser and from the drop down click on Create.
This opens the create table window as shown. You are also provided a listing of all existing tables which should help you to not use an existing table name. To see all the tables, you need to click on the indicated place, which will reveal two frames as shown (a list of tables will be shown when you click in the indicated place).
On the left hand side of the right hand frame you have the various Wizard steps. First and foremost is a name for the table. The table will be called Htek_Employees. By concatenating Htek_ to Employees you are avoiding two pitfalls: you are not giving a duplicate name (an Employees table already exists) and you are not using a keyword. The table name will be typed with all characters capitalized as shown. Clicking on the red star to the left opens up a little pop-up, giving you a hint as to what constitutes a good name for the table.