iSelfSchooling.com - Copyright © 1999-2007 iSelfSchooling.com  References  Job Openings  |  Secure Login
    Home  | Search more...  |  FREE Online VIDEO Oracle Training  |  Gift Store  |  Bookstore

   Unlimited access!   

    Oracle  Syntax  | Suggestions Your Contribution  |  FREE Legal Forms

 

Email2aFriend Homepage us! |  Bookmark   -  Copyright & User Agreement

Products/Services

 Vision/Mission

 Community Sharing

 Services

  Products

 Biography

 Contact Us

 FAQ

 Current News

 Website Traffic

 Bookstore

 FREE Training

 SQL

 PL/SQL

 Forms 

 Reports

 Other TOOLS

 Fundamentals

 Performance

 OEM

 Application Server

 Grid Control

 Articles

 Prepare for OCP

Oracle SYNTAX

 Oracle Functions

 Oracle Syntax

 Oracle 10g Syntax

  PL/SQL Syntax

UNIX and more...

 UNIX for DBAs

 LINUX for DBAs

 DB using PHP

  A+ Certification

 Basics of JAVA  

 Tips of  SEO

Finance/Jobs

 Financial Aid

 Skilled

 Oracle

 Jobs

  Magazine

More Training

 Q & Answers

 SQL-PL/SQL

 DBA

 Developer

 Important Notes

 Case Studies

 9i New Features

 10g New Features

 10g Qs/As

 Grid Control

 OracleAS # I

 OracleAS # II

  LDAP and OID

  HTTP Server

 Instructor-Led

  Virtual Hosts

 Community Sharing

More to know...

Acknowledgement**

 FREE Legal Forms

 Who is who

 Market Place

 University Directory

 Advisory Articles

 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