Sumário Itens Encontrados: 260Chapter 1: OHS,EPG,and APEX Listener ComparedWhy Should I Care About This Chapter?Web Server BasicsThe Oracle HTTP Server (OHS)Installing the OHSConfiguring the OHSDigging into HTTPD.CONFConfiguring Virtual HostsPrefork or Multi-Processing Module?Web Server CompressionExpiry Headers.Embedded PL/SQL GatewayCompression and Expiry Headers with the EPGConfiguring SHARED_SERVERS.Configuring EPG Parameters and DADSDebugging Issues with the EPGConfiguring Virtual Hosts with the EPG.The APEX ListenerStand-Alone InstallationInstalling via Glassfish or Web Logic Server.Compression with the APEX ListenerInteresting APEX Listener FeaturesConclusionChapter 2: Oracle APEX 4.0 Charts Inside OutHTML ChartsUsing the HTML Charts WizardThe Result.Debugging and PerformanceBehind the ScenesInline HTML Charts in Report.Flash Charts.BackgroundCreating a Flash ChartUnderstanding the Chart Region.Understanding the Chart AttributesAdding Multiple Series and Combined ChartsDifferent Flash Chart TypesDebug and PerformanceUpgrading Oracle APEX 3.x Flash and SVG Charts.Screen Reader Mode and ChartsExtending Flash ChartsCustomizing Charts by Using Custom XML.Customizing Charts by Using Custom XML,Dynamic Actions,and JavaScriptCreating Charts ManuallyDrill-Down Charts,Dashboards,and Interactivity.Simple Dashboard with SubmitSimple Dashboard with JavaScriptComplex Dashboard with Actions.Most Common IssuesSearch for a Specific FeatureInvalid #HOST# with Reverse Proxy or HTTPS.Flash Security ErrorCharts in the FutureResourcesChapter 3: Tabular FormsChanges in APEX 4.0ConstraintsPurpose of Tabular FormsTabular Forms Are Not Spreadsheets.New Features in APEX 4New Item Types.Declarative ValidationsOther Features.Future Features Weâd Like to SeeCustom Coding in Tabular Forms.Processing the Correct RowsData IntegrityManual Tabular Forms.Tabular Forms and CollectionsInteresting TechniquesSimple AutocompleteAutocomplete Returning Key ValueClone Rows.Chapter 4: Team DevelopmentMilestonesThe BasicsExtending Milestone FunctionalityFeatures.Extending the Features FunctionalityTo DoâsExtending the To Do FunctionalityBugs.FeedbackFeedback ProcessEnable FeedbackExporting Feedback to DevelopmentImporting Feedback into DevelopmentProcessing FeedbackExporting Response to Deployment.Importing Response into Deployment.Extending Feedback: Create a ReportExtending Feedback: Feeding Back the Follow Up.Further EnhancementsWrap UpChapter 5: GlobalizationLoading LanguagesTranslating ApplicationsApplication Language Derived From.Mapping.CSV EncodingTranslating an Application.Manually Translate an ApplicationTranslating Data in the DatabaseDynamic TranslationsTranslating APEX Internal TextCopying Translations to Other Environments.Copying Only the Applications.Copy the Primary Application and Publish.Changing the Application IDLocalization.SINCE Format Mask.Numeric Formats.Time Zones and Territories.Switching LanguagesTranslation logsDeveloper Log.DashboardChapter 6: DebuggingPrinciples of Code Instrumentation.Debugging Basics.Page Processing and Rendering.Enabling DebugDebug Information.Benefits of Debug ModeGraphs and ChartsInteractive ReportsAPEX Debugging APIAPEX_DEBUG_MESSAGEProgrammatic Debugging.Instrumenting Your Own CodeThe Data Behind DebuggingTables and ViewExamining the Debug DataUsing Debug Data for More Than DebuggingDebugging Dynamic ActionsWhat Debug Doesnât Capture.AJAX Calls.ReportsChapter 7: Dynamic ActionsCustom JavaScript vs. Dynamic ActionsManual (Old Method)Dynamic Action (New Method)Dynamic Actions in DetailIdentification.WhenAdvanced.ActionsDynamic Actions in ActionBusiness CaseSetupCreate Department Employee ReportRefresh Department Employees ReportHighlight RowRow ClickEmphasize Employee ChangeModal Window.Chapter 8: SecurityTools and Techniques.Authorized AccessAn APEX ExampleThe Real SolutionDenial of ServiceDenial of Service in an APEX EnvironmentThe DetailsThe FixSQL InjectionA SQL Injection Primer.Custom Developed Applications vs. Commercial Off the Shelf ProductsSQL Injection in an APEX EnvironmentPassword CrackingCross Site ScriptingChapter 9: Lifecycle ManagementChallengesWorking Concurrently on the Same Source Code.Propagating All Required Changes for a New Release.Parallel Development on Different Application VersionsWhat Is the Current Status?Which Requirements Were Implemented in This Release?The Sample ApplicationThe Approach.Version Numbering Scheme and the Overall Delivery ProcessStoring Files on the Application ServerRequirements for Designing the Server Environments.Project Management Related Aspects.Version ControlNaming Conventions.Naming Conventions for the File System.Rollout ProceduresInitialize PatchMaking Changes.Finalizing the PatchInstallation in the Test EnvironmentUpdate the Documentation.Installation in the Production Environment.Chapter 10: Working with APEX CollectionsWhen to Use APEX Collections.Session State Management: A Quick Overview.Session State Managed TablesLogically Walking Through a Web Shopping Cart Implementation.A Look Under the CoversPrivate Collections Objects Inside the APEX EnginePublic Collections Objects Inside the APEX EngineGetting Started with CollectionsInitializing a CollectionAdding and Removing Data from CollectionsUsing the CollectionExpanding Our ExamplePassing Data to the FormCreating a Tabular Form to Be ValidatedCollecting and Processing Submitted DataChapter 11: Plug-Ins.The APEX Plug-in ArchitectureCreate/Edit Page for Plug-insPL/SQL APIsOther Tools of the TradejQuery UI Widget FactoryjQuery UI CSS FrameworkPlug-in TutorialsDeveloping a Process Plug-in.Developing a Dynamic Action Plug-inDeveloping an Item Plug-inDeveloping a Region Plug-inBest Practices for Developing Plug-insChapter 12: ArchitectureOracle APEX EngineInstalling and Upgrading.ApplicationsApplication PagesSession State Management.Connection ManagementApplication LoggingRunning SQL and PL/SQL Contained Within an Application.Workspaces and Multi-TenancyAutomatic Data Manipulation Language (DML)Application ExtensibilityCustomizing User Interface Templates.Using Static HTMLUsing PL/SQL to Generate HTMLPlug-InsSeparation of Presentation and Logic.Chapter 13: Advanced Interactive Reporting.Creating a ReportData FormattingReport and Column AttributesColumn GroupsIncluding LinksFiltering Using ItemsColumn List of ValuesCreating Default and Saved Reports.ChartingLinking to Saved Interactive Reports.Report SettingsReport-Level SettingsColumn-Level SettingsUtilitiesAPEX_UTIL functionsUser Interface DefaultsActivity LogSecurity.Performance