iSelfSchooling.com  -  Since 1999  References  |  Job Openings  |
    Home  | Search more  | Oracle Syntax  | Instructor-Led in Class   | Members - (Thousands)
 

Copyright & User Agreement

   Suggestions Email2aFriendHomepage us! |  Bookmark

Services

  Vision/Mission

  Services

  Biography

  Contact Us

 FREE Training

  Start...

  SQL

  PL/SQL

  Forms 

  Reports

  DBA Fundamentals

  Performance

  Prepare for OCP

  Instructor-Led

  ShareUrNotes

. . .

  Acknowledgement

  Who is who

  University Directory

  Links...

 

 

 

Topics:  Hands-On 06 - Developer Tools (Graphics Builder)

Graphics Builder lets you to create interactive graphical displays of the data in a database. You can include these graphics in your forms or reports.  Graphics Builder provides a complete set of drawing and editing tools, along with a “Chart Wizard” to simplify the process of using the tools.

In this Hands-On, you learn how to:  Create a chart, Write a query, Execute a query, Modify a query, and Save a chart.

You will create a chart to show a salary distribution in each department.

 

More Resources by Google:

Manuscript

Open the “Graphics Builder” tool.

Create a chart to show a salary distribution in each department.

 

Click on the "chart” icon.

 

Drag the cursor and click anywhere on the “layout editor.”

 

Type the query name.

Write a query to show the total salaries paid for each department. 

 

Click "execute" and login as iself password “schooling” then click “CONNECT.”

 

Check the query.

 

Click “OK.”

 

Type the chart’s name and it's title (Salary Distributions).

Select the type and subtype.

 

Click “OK.”

 

This is the chart.

 

Change the department number to department name.

 

Click on the “SQL” icon.

Join the employee table with the department table and add the department name to the query.

 

Click “OK.”

Click “Yes,” to remove the department number from the chart.

 

This is much easier to understand, than the previous chart.

 

Save the chart in the “iself” folder using the “file system” option. 

 

Now, you should practice this over and over, until you become a master at it.

Good Luck.

 

 
 
Google
 
Web web site