Creating a Table using Oracle 10G XE - Creating a table using the Wizard
(Page 3 of 4 )
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.
Next: Creating a table using the Wizard, continued >>
More Oracle Articles
More By Jayaram Krishnaswamy
