Oracle Developer使用指南 (7)

8OracleDeveloperGraphics()GraphicsGraphicsRuntime()PL/SQLGraphicsGraphicsGraphics8.1GraphicsBuilder8.1OracleDeveloperGraphics4Talbot()Talbot4(8-1)/TalbotTalbot8-1TalbotLedger(SoldReceivedPaidBought)8-28-3Talbot81738-2Talbot8-3Talbot()OracleDeveloper174OracleDeveloper00EdwardR.TufteTheVisualDisplayofQuantitativeInformatin(GraphicsPress,1983)WilliamS.ClevelandTheElementsofGraphingData(WadsworthAdvancedBooksandSoftware,1985)JacquesBertinSemiologyofGraphics:Diagrams,Networks,Maps(UniversityofWisconsinPress,1983)8.2ChartGenie4OracleDeveloper(Graphics)ChartGenieLayoutEditor/8.2.14ChartGenieNewQuery4ChartGenie1.OracleDeveloperChartGenieSELECTObjectNavigatorPropertyPalettePL/SQLOG_Make_QueryOG_Execute_QueryData1)108175QueryBuilderOracleDeveloperGraphicsChartGenieQueryNewQueryASCIISelectSQL*plusSQLSQLStatementImportSQL8-48-4SQLStatementOpenSQLStatementSQLSQLStatementSQLExecuteDataExportSQLSQLSQLTypeExternalSQLFile(SQL)FileBrowse8-5BrowseOpen8-5BrowseOpenSQLSQLChartGenie2)•SYLKMicrosoftExcel/Multiplan•WKSLotus1-2-3•PRN()8-6BrowseOpenData176OracleDeveloper8-6OracleSQLOracleDataJunctionbyToolsandTechniques3)OG.Open10FormsChartGenieChartPropertiesChartPropertiesDataUpdatechartonqueryexecution8-7OracleDeveloper8-7Updatechartenqueryexecution2.SQLWHERE10WHEREPL/SQLSQL()ChartPropertiesDataFilter8-88-8DataNewGraphicsPL/SQLProgramUnitEditor8177BEGINENDTRUEFALSEGraphicsFALSE8.2.2(8-9)XY8-919018-98-9XLedger178OracleDeveloperMonthNumberMonthWHERE1901GroupBYMonthMonthNumberSELECTGROUPBYChartGenie?8.2.3ChartPropertiesChart|PropertiesPropertiesChartPropertiesChartGenie1.ChartFrame()Axes()FrameFrameProperties8-10Frame8-10FrameShowPlotFrameShowLegend()8-11AxisFrame()81798-11AxisFrameShowSecondYAxis(Y)YBaselineMapping()CategoryWidth()AxesAxisProperties()AxisContinuousAxis()DiscreteAxis()8-12Axis8-12AxisCustomLabel()Data180OracleDeveloperType()ChartProperties()8-13DiscreteAxis()auto()8-13DiscreteAxisauto8-14(ContinuousAxis)8-1481812.Format()()FieldTemplate()Chart()108.2.4(8-15)8-1519018-158-15182OracleDeveloperGROUPBYORDERBYWHERE1901(Histogram)XY8-161901GROUPBYISOSELECTCount(*)ORDERBY(8-16)8-168.2.5(8-17)FrameProperties()PieFrame()(8-18)4PieFrame8.2.3Frame8183ShowLegend()8-178-18PieFrame8.2.6SoldOracleDeveloperGraphicsGraphicsRuntime184OracleDeveloperSold8-198-19SoldChartProperties()XSQL19011)LayoutEditor(LayoutEditor)2)Properties()Tools|Properties(|)3)Drill-down(8-20)4)SetParameter()New()OracleDeveloperParameters()8-215)PERSONGeorgeB.McCormick(CHAR)NUMBERDATE6)OKOracleDeveloper81858-20Drill-down7)Drill-downToValueOfPerson8)ExecuteQuery(QUERY0)8-22ExecuteQueryNew()Edit()9)EditPersonPersonName:Person10)GeorgeMcCormick8-238-23GraphicsRuntime,186OracleDeveloper8-21Parameters8-22Drill-downLayoutEditorRUN8.3GraphicsLayoutEditor8.3.1EditorShiftRectangle()Line()Ellipse()Arc()Polygon()Polyline()RoundedRectangle()Freehand(),8-24(Rotate)SHIFT45(ModifyShape)(FillColor)(NoFill)(LineColor)(NoLine)Format()DrawingOptions()8.3.25GraphicsRuntimeForms81878-24Graphics8-91)8-25ObjectPropertiesTools|Properties()2)ProcedureNew()ProgramUnitEditorBEGINENDPL/SQLFormatTrigger()GraphicsTools|DisplayDisplayPropertiesOpenCloseObjectNavigatorPostExecution()Timer()TimerProcedure()PL/SQLPL/SQL101112Graphics11OracleDeveloperGraphicsOG_INCHPL/SQLaRect(24)OracleDeveloperPL/SQL188OracleDeveloper8-25Object