Using the sample database - 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

Oracle 10g XE comes with a sample database called HR which stands for human resources. However, this database is locked when installed. You need to unlock it before you can use it. Click on Administration, then click on the HR icon. The first click opens the following screen.

The second click on the HR icon opens the screen as shown here. Enter hr for both username and password and make sure the unlocked choice is showing on this screen for Account Status. Make sure that both Connect and Resource are checked for the "Roles" before you click on the Alter User button which makes the requested changes to the User. Now you are rocking! You will be able to access the HR database.