Home arrow Oracle arrow Learning to Query in Oracle XE

Learning to Query in Oracle XE

Querying the database is one of the most common tasks that you may have to carry out routinely. This tutorial shows you the options for running SQL queries and how to run the queries against the database in the Oracle Express Edition, Oracle XE for short.

TABLE OF CONTENTS:
  1. Learning to Query in Oracle XE
  2. Running SQL Queries
  3. An Example from PL/SQL
  4. Example 3: Dual Tables
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 26
June 07, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Introduction

In order to get information about logging in and out of Oracle XE, please review my first article which gives you an overview of Oracle XE.

You can access the login page by going from the shortcut Go To Database Home Page... shown in the next picture.

This opens up the login page shown in the next picture. It is assumed that you can log in to the HR database, which has a couple of tables. If you have not reviewed the previous article, you logged in as System with the password you gave yourself and then unlocked the HR database; otherwise you will not have permission to access the HR database. Please review the previous article. 

This takes you to the HR database where the user hr has logged in as shown here, showing all the available objects. Since you will be looking at SQL,  click on the icon SQL. If you click on the drop-down you will get a menu from which you may have to choose.

 

Clicking on the icon  opens three more icons, all related to SQL. They are
SQL Command, SQL Scripts, and Query Builder.

In this tutorial you will look at using the SQL Commands. Click on the icon SQL Commands, or on the drop down.

 

When you click on the icon you get the next screen as shown. In this window you will be typing in the SQL and displaying the results of your SQL Query. In the upper pane you type in your SQL statement and in the bottom, tabbed pane you get the results. The Results tab is the default. Once you get the results you can look at several related facts, as shown in this picture, by tabbing the various items.



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