Table of Contents
Oracle Application Express App Builder User's Guide
Quick StartApp Builder ConceptsUnderstanding Oracle Application Express ApplicationsRunning an Application or PageHow Does Page Processing and Page Rendering Work?Understanding Session State ManagementUnderstanding URL SyntaxManaging Session State ValuesUsing Substitution StringsUtilizing the App GalleryManaging the Application Life Cycle with Team DevelopmentCreating Websheet ApplicationsCreating Database ApplicationsUnderstanding Page Types, Features, and SettingsCreating a Database Application from a SpreadsheetUsing Application BlueprintsCopying a Database ApplicationCreating Applications for Mobile DevicesDeleting an ApplicationManaging Application AttributesAdding Developer CommentsUsing the Find IconManaging Application GroupsUsing Application UtilitiesManaging Pages in a Database ApplicationEditing Pages in Page DesignerUnderstanding Page Designer UI ElementsUsing Page DesignerManaging Page AttributesDeleting PagesDeveloping ReportsUnderstanding Report TypesCreating a Report Using the Create Application WizardCreating a Report Using the Create Page WizardManaging Interactive GridsManaging Interactive ReportsManaging Classic ReportsPrinting Report RegionsUnderstanding BLOB Support in Forms and ReportsDeveloping FormsManaging Database Application ComponentsUsing Themes and Theme StylesUsing ThemesManaging Themes and SubscriptionsCreating Custom ThemesUsing Custom Cascading Style SheetsControlling Page LayoutManaging Database Application ControlsAdding NavigationManaging Computations, Validations, and ProcessesUnderstanding Page ComputationsUnderstanding ValidationsUnderstanding Page ProcessesUnderstanding Application ProcessesUnderstanding Application ComputationsUsing the Attribute DictionaryManaging Shared ComponentsShared Components PageManaging Application SettingsCreating Lists of Values at the Application-LevelManaging Component SettingsUsing ShortcutsManaging Email TemplatesManaging Static Application FilesManaging Static Workspace FilesManaging Application-Level ItemsCreating ListsManaging Report OutputManaging Application DataCreating Applications with Data Loading CapabilityManaging REST Enabled SQL ReferencesManaging Web Source ModulesManaging Remote ServersManaging Web CredentialsManaging Legacy Web ServicesAccessing Data with Database LinksAbout DML LockingExtending Application CapabilitiesSending Email from an ApplicationImplementing Plug-insUnderstanding jQuery and jQuery UI SupportManaging Application SecurityUnderstanding Administrator Security Best PracticesUnderstanding Developer Security Best PracticesControlling Access to Applications, Pages, and Page ComponentsEstablishing User Identity Through AuthenticationProviding Security Through AuthorizationManaging Application GlobalizationUnderstanding Application Translation and Globalization SupportUnderstanding the Translation ProcessTranslating MessagesTranslating Data That Supports List of ValuesUnderstanding Supported Globalization CodesManaging Application PerformanceIdentifying Performance IssuesUtilizing Logs and ReportsCreating Custom Activity Reports Using APEX_ACTIVITY_LOGDebugging an ApplicationDeploying an ApplicationSystem Development Life Cycle Methodologies to ConsiderUnderstanding the Deployment ProcessHow to Create a Custom ApplicationUsing Build Options to Control ConfigurationExporting an Application and Application ComponentsImporting Export FilesInstalling Export FilesManaging Application Legacy ComponentsAbout Item TypesOracle Application Express LimitsAvailable ConditionsAbout Granted PrivilegesOracle recommends developers follow standard system development life cycle practices when developing applications by having different environments for development, testing, and production.
As a best practice, developers should only make changes to applications and related database objects in the development environment. To further enforce this policy Oracle recommends that you install runtime-only Oracle Application Express environments in your test and production environments. This will prohibit developers from accessing the App Builder and SQL Workshop in these environments. As a general rule, your administrator (DBA) should be the only ones with permission to update the test and production environments. DBAs should use the appropriate provided APIs and import applications from an SQL interface, such as SQL Developer or SQL*Plus.
Parent topic: Deploying an Application