Home arrow Oracle arrow Page 3 - Using Query Builder in the Oracle 10g Express Edition

A simple SELECT query - Oracle

In an earlier tutorial we saw how to use SQL commands in the Oracle 10g Express Edition, or simply Oracle XE. We also saw how to use the PL/SQL commands as well. In this tutorial we will see how to use the Query Builder, the graphical interface for fashioning and running SQL in the Oracle XE. The tutorial shows how to interact with the query builder to create a SELECT query in the context of a single table as well as a SELECT query from two related tables.

TABLE OF CONTENTS:
  1. Using Query Builder in the Oracle 10g Express Edition
  2. Querying a single table
  3. A simple SELECT query
  4. Creating a SELECT query with a WHERE clause
  5. Creating a SELECT query on two tables which are related
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 14
June 14, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Let us follow a simple query. We'll be doing nothing fancy; three columns are chosen and nothing else. We show just the default view of the condition tab when the three columns are added.

Clicking on the SQL tab will show the following window. This screen cannot be edited here. If you want to replace "LAST_NAME" by a friendly Name "Last name" you have to return to the Condition tab and change the "alias."

Now click on the Results tab. You will see the following screen.



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