HomeOracle 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.
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.