Home arrow Oracle arrow 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.

TABLE OF CONTENTS:
  1. Creating a Table using Oracle 10G XE
  2. Creating a table
  3. Creating a table using the Wizard
  4. Creating a table using the Wizard, continued
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 37
September 19, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

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.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: