Getting used to tables in hr - Oracle

There are plenty of companies that produce large, expensive database programs with lots of features. But if you're a small company, you don't need to spend a lot of money to get a database that suits your needs; in fact, you may not need to spend any money at all. This article introduces you to Oracle 10g XE, a free database with a friendly user interface.

TABLE OF CONTENTS:

By: Jayaram Krishnaswamy

Poor Best

Rating:

/ 26

May 23, 2006

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

Click on the Object Browser icon after logging in with hr, hr credentials. You will see the following in the default view. On the left you see the various objects with the Tables as the default. Clicking on the drop-down arrow you may access other objects. In this window you may also start creating various objects by clicking on the Create button. In the search box just below the Tables drop-down you may also search for table objects by entering a single letter.

You can look at all the existing tables by clicking on the table name, say Departments, which fills the table design information on the right pane as shown here.

Summary

The tutorial introduces the readers to Oracle XE. The user interface is very user friendly, colorful, and well documented. The tutorial describes how to get authenticated as a user and access the various resources. The object browser which is the window to the objects is described. Future tutorials will focus on hands-on guidance to the use of objects, SQL, and application development using this interface.