Oracle_ch10_Morrison

Oracle_ch10_Morrison - ORACLE 10 Using Graphics Builder...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
ORACLE - 10 Using Graphics Builder Jason Chen, Ph.D. Professor of MIS School of Business Administration Gonzaga University Spokane, WA 99258
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
TM Oracle-2 Oracle for Business Database Systems - Dr. Chen Term Project e 1. Follow the format and requirements stated on the syllabus and samples. . 2. SDLC approach . 3. Database design requirements . ER-D, Functional dependency, normal forms . 4. Oracle implementation . Database creation, report, graphics (chapters 9A, 10) . Charts with form (chapter 10 p.904-922)
Background image of page 2
TM Oracle-3 Oracle for Business Database Systems - Dr. Chen Registering Oracle File Extensions and Installed Folders (Select View then folder options then …) 1 *.BRW: Query Builder; oracle\oraDev\bin\QBE60.exe 2 *.PLS: Procedure/Program Builder; oracle\oraDev \bin\DE60.exe *.PLL: Library 3 *.FMB: Form Builder; oracle\oraDev\bin\ifbld60.exe *.FMX: Form Module Executable; oracle\oraDev\bin\ifrun60.exe Form Runtime oracle\oraDev\bin\ifdbg60.exe Form Compile oracle\oraDev\bin\ifcmp60.exe 4 *.RDF: Report Builder; C:\oracle\oraDev\bin\RWBLD60.exe *.REP(executable file); C:\oracle\oraDev\bin\RWRUN.exe *.TDF (template file) 5 *.OGD: Graphics Builder (design file) -- note that the text listed wrong information oracle\oraDev\bin\GOBLD60.exe *.OGR Graphics Runtime; oracle\oraDev\bin\GORUN60.exe
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
TM Oracle-4 Oracle for Business Database Systems - Dr. Chen Graphics builder is a developer utility used for creating graphical displays of database data. All labels and values that appear on charts is retrieved from the database. . Oracle graphics builder applications can run as stand alone applications, or they can be embedded within forms or reports. Graphics Builder
Background image of page 4
TM Oracle-5 Oracle for Business Database Systems - Dr. Chen Chart Types e Column . Shows discrete values using vertical columns . Bar . Shows discrete values using horizontal bars . Gantt . Shows task or project scheduling information using horizontal bars
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
TM Oracle-6 Oracle for Business Database Systems - Dr. Chen More Chart Types e High-Low . Shows multiple Y-axis values for each X-axis point . Line . Shows data values as points connected by lines to show trends . Mixed . Combines a column and line chart
Background image of page 6
TM Oracle-7 Oracle for Business Database Systems - Dr. Chen More Chart Types e Pie e Shows how individual data values contribute to an overall total . Scatter . Plots 2 sets of potentially related data to identify possible trends . Table . Shows text data in a table
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
TM Oracle-8 Oracle for Business Database Systems - Dr. Chen More Chart Types e Double-Y . Shows a column or line chart with multiple values for the same X-axis value
Background image of page 8
TM Oracle-9 Oracle for Business Database Systems - Dr. Chen Steps of using the Chart Genie to create a chart Specify the SQL query to retrieve the chart data from the database Select the chart type Define the chart display properties Creating a Chart
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
TM Oracle-10 Oracle for Business Database Systems - Dr. Chen Creating a Pie Chart
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/26/2010 for the course ITS 26 taught by Professor Jack during the Spring '10 term at Staten Island.

Page1 / 53

Oracle_ch10_Morrison - ORACLE 10 Using Graphics Builder...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online