Querying Oracle 10G XE using Sun Java Creator 2

Please review the articles on Oracle 10G XE at the sister site Devshed.com. You can create a table in Oracle 10G XE after logging into the database and accessing the Create-->Table shortcut from the home directory as shown in the next picture.

This opens the graphic user interface wizard which is used for creating a table as shown. The name for the validation table is OraVal (the name given can be anything that is allowed) which is inserted for the table name. It has only one column, Val_ID, which has a numeric data type as shown in the picture.

In the next step, you provide the Primary Key - Val_ID and create a Sequence as shown. The Primary Key is the column created in the earlier step. The sequence is a new sequence called ORAVAL_SEQ, the default.

Skip this step where you need to provide a foreign key. This table will have only one column.

You accept the default provided by Oracle and move on to the final step.

Here your confirmation is needed for creating the table. The table ORAVAL will be created in the HR Schema when you click on the Create button. When you expand the SQL button, you can review the SQL statements that created the table. If you need to see the table structure you may go back to the object browser and look at the list of tables in the HR Schema.