Query Builder

Query Builder is an entirely separate Oracle product, however within Reports 10g, Oracle has created a cutdown version for selecting data only, basically it allows the Developer to grab tables and their columns, apply functions to them and when complete return to Reports 10g with the SQL query built. 

Using Query Builder to its fullest extent is a course in itself, however, the following slide outline the main functionality of the product with reference to its usage in Reports 10g. 

Before Query Builder will begin, if the Developer is not already connected it will prompt them to connect. One other point, if there is SQL already written in the Data Source Definition and is in error then Query Builder will repeat that error message when it opens

Query Builder will display a list of all tables/views available for the

Developer to select from the current schema

Display1

 

 

 

 

 

 

 

 

 

 

This dialog will not close automatically and each table included will be entered into the dialog behind it ….

Here the Developer has selected the Products table and has clicked on several columns to select them …

 

 

 

 

 

 

 

 

 

 

 

To create an Order By clause the Developer must click on the nineth button from the right which displays the columns which are available for sorting …

display3

 

 

 

 

 

 

 

To create a condition, click on the left hand panel, then either manually enter the condition or double click on the required column and enter the condition needed, here the Developer is limiting records with a Product Number of 9. display5    

 

 

 

 

 

 

 

 

Clicking on the green tick button will accept and check the condition, if it is correct then a second input line will appear …

display5

 

 

 

 

 

 

 

 

 

To create a column with a function around it, click on the button with the green plus sign above a disk pack, this will display the following dialog to define a new column.

display6

 

 

 

 

 

 

 

 

The Developer must first name the new column, this will then allow access into the ‘Defined as’ area where the new column can be set out, this will also enable the Paste Column and Paste Func buttons from which the Developer can select

display7

 

 

 

 

 

 

 

 

 

display8

 

 

 

 

 

 

 

Here the Developer has created a new column called

‘lowered_description’, this will now appear in the list of columns and subsequently in the Data Source Definition dialog …

 display9

 

 

 

 

 

 

 

display10

 

 

 

 

 

 

 

This example is now ready for the Developer to move onto the next option or apply column aliases/labels

display12

 

 

 

 

 

 

 

Advertisements

About Oracle Technology Blogs
Oracle Application Development

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: