-
Book Overview & Buying
-
Table Of Contents
Oracle SQL Developer 2.1
By :
SQL Developer provides a visual Query Builder to help you create queries. A visual Query Builder is useful when you are building complex queries based on a number of tables. It is also useful for users who are new to Oracle and SQL and are not familiar with writing SQL queries.
The Query Builder allows you to select any table or view you have permission to access. The schemas are all displayed in the drop-down list in the top left-hand corner. The initial user displayed is the current connection. Select one or more tables and drag them onto the work surface. You can rearrange the tables to suit your needs.
You can spend time moving back and forth between the editors, reviewing the query results, and fine-tuning the selection criteria. As soon as you select the Apply button, the query is written to the SQL Worksheet and the Query Builder is closed.
To invoke the Query Builder, use the context menu on the SQL Worksheet, or PL/SQL editor for your database connection. The...
Change the font size
Change margin width
Change background colour