5.3 Using Query Builder

Use Query Builder to build queries graphically by adding tables to a panel and selecting the columns to return.

Query Builder's graphical user interface enables database developers to build SQL queries without the need for manual SQL coding.

Using Query Builder, you can search and filter database objects, select objects and columns, create relationships between objects, view formatted query results, and save queries with little or no SQL knowledge.

Tip:

SQL commands created in the Query Builder can be accessed from SQL Commands.

• Accessing Query Builder
  Learn how to access Query Builder.
• Query Builder Home Page
  Learn about Query Builder home page.
• Understanding the Query Building Process
  Learn how to build a query in Query Builder.
• Using the Object Selection Pane
  Use the Object Selection pane to search for and view tables, views, and materialized views within the current schema as well as select objects.
• Using the Design Pane
  Learn about how to use the Design pane.
• Specifying Query Conditions
  As you select columns within an object, you can specify conditions on the Conditions tab.
• Creating Relationships Between Objects
  You can create relationships between objects by creating a join.
• Working with Saved Queries
  You can create queries and save the query for later use.
• Viewing Generated SQL
  The SQL view presents a read-only, formatted representation of the SQL generated by Query Builder. You can copy the SQL code that appears in the SQL View for use in other tools such as SQL Command Processor or App Builder.
• Viewing Query Results
  Execute a query, once you select objects and determine what columns to include in your query.

See Also:

Using SQL Commands