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.

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