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

Starting and stopping the 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

As you can see from a previous picture which shows the Windows services, Oracle XE starts automatically when the Window OS starts. You can also start, stop, and pause the server from the services screen.

When XE is installed, several shortcuts are also added to All Programs (in Windows XP Professional) as shown in the next picture. What you would be doing normally is start and stop from the shortcut. When you click on the Go to Database Home Page... shortcut, you will encounter the login screen shown in the next section.

Logging on as System

In the beginning you will be logging on as SYSTEM using the password that you chose in an earlier step. I hope you did save the password. Enter the credentials now. Note that there are a number of useful links which will enlarge your view of XE as well as allow you to participate in forums where you can pose your questions.

Now with these credentials entered you will get to the next screen, which shows you a pretty neat, tidy and well organized UI. Now there are four main areas that you should know about. These are Administration, SQL, Object Browser, and Utilities. Each of these is a node with several child nodes which you will access. 

Clicking on the Administration Icon on the down arrow marked 2 pops up other menu drop-downs from which you may access the particular drop-down menu. This interface is very convenient for accessing the specific area in which you are interested. You don't have the Microsoft Menu style, but still this is as good as the menu system you may be very familiar with from other software.

On the other hand, if you click on the icon at the position marked 1, you will find the following screen.

The Object Browser gives you access to all the database objects, such as tables, views, functions, and so on as shown in the next picture.

The SQL icon gives you access to the SQL Commands, SQL Scripts, and the Query Builder.

Of course, you cannot do without utilities, and this next screen gives access to the various utilities.



 
 
>>> 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: