Using Query Builder in the Oracle 10g Express Edition - Creating a SELECT query with a WHERE clause
(Page 4 of 5 )

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.

Next: Creating a SELECT query on two tables which are related >>
 

More Oracle Articles
More By Jayaram Krishnaswamy

Comments On: Using Query Builder in the Oracle 10g Express Edition

· Coding queries and running queries are the most frequent chores you would be doing...   >>> Post your comment now!