 Oracle Page 4 - Using Query Builder in the Oracle 10g Express Edition |
Creating a SELECT query with a WHERE clause - OracleIn 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.
print this article SEARCH DEV SHED |
Employees hail from different cities. You could find all those from, say, "Seattle" by imposing a condition. The following qualified Select will show just that. You qualify your Select by typing in the condition '='Seattle' in the Condition part of the GUI as shown.  Now the window in the SQL tab will show the following content:  The Result tab will show the following window.
blog comments powered by Disqus |
/ 14 
Oracle Database XE: SQL and SQL Plus
