Home arrow Oracle arrow Page 3 - Experience the Possibilities with Oracle 10g Express Edition

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:
  1. Experience the Possibilities with Oracle 10g Express Edition
  2. Starting and stopping the database
  3. Using the sample database
  4. Getting used to tables in hr
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 26
May 23, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

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.



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

blog comments powered by Disqus
   

ORACLE ARTICLES

- 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
- Using the IN and BETWEEN Operators on Tables
- Clauses and Logical Operators for Retrieving...
- Limiting Rows When Retrieving Table Data
- Using Scalar Functions for Retrieving Data
- Retrieving Data with String and Arithmatic E...
- Coding the SELECT Statement
- Oracle Releases iPad Virtual Desktop and Exa...


© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 3 - Follow our Sitemap

Dev Shed Tutorial Topics: