Transcription
ORACLE DATA SHEETORACLE APPLICATION EXPRESS 5.0Oracle Application Express is a declarative, rapid web applicationdevelopment tool for the Oracle Database. It is a fully supported,no cost option available with all editions of the Oracle Database.Key Features Fully supported nocost feature of theOracle Database Simple 2-TierArchitecture Develop desktopand mobileapplications 100% Browserbased Developmentand Runtime Very advancedBrowser-based IDE PackagedApplications Runs everywhereOracle DatabaserunsOracle Application Express enables you to create database-centricWeb applications that are reliable, scalable, and secure. Usingonly a web browser, and with limited programming experience, youcan develop and deploy professional Web-based applications fordesktops and mobile devices.Figure 1: Application Express Development Home PageFully Supported no-cost Feature of the Oracle DatabaseOracle Application Express is a fully supported, no cost optionof the Oracle Database, and is installed by default in all editionsof the Oracle Database. Oracle Application Express runseverywhere and anywhere Oracle Database runs. It is distributedwith all editions of Oracle Database 11g and Oracle Database12c. You can also download the latest Oracle ApplicationExpress software from the Oracle Technology Network athttp://otn.oracle.com/apex.
ORACLE DATA SHEETKey Benefits Modern WebApplicationDevelopment madeEasyDeclarativeframework for rapidapplicationdefinition,maintenance, andenhancementsDesktop and mobileWeb applicationdevelopment madeeasier and fasterLeverages SQL andPL/SQL skills andbuild applicationsthat are reliable,scalable, and secureImprove developerproductivity byusing Page DesignerDevelop beautifuland responsiveapplications byusing UniversalThemeFlexibleDeploymentOptionsSimple Two-Tier ArchitectureOracle Application Express uses a simple architecture wherepages are dynamically generated using metadata stored withinthe Oracle Database. There is no code generation or file basedcompilation. Once fully installed, a Uniform Resource Locator(URL) is defined for both developers and end users to accessOracle Application Express. Users require only a Web browserand the required URL. No additional client software is required.The Web Listener functions as a communications brokerbetween the Web browser and the Oracle Application Expressobjects in the Oracle database, by mapping browser requestsinto database stored procedure calls.You have a choice of three Web Listeners. Oracle REST Data Services, a Java based free tool andthe preferred option for use with Oracle ApplicationExpress Embedded PL/SQL Gateway Oracle HTTP ServerMulti-tenant HostingOracle Application Express enables a single database to hostlarge number of applications and users. Developers work in adedicated work area called a Workspace to develop applicationsagainst one or more schemas. This flexible architecture enablesa single database instance to act as a Platform as a Service(PaaS), providing a hosted Intranet capability within theorganization, or hosted Internet service.Modern Web Application Development Made EasyAn Oracle Application Express application enables you tomanage and display data from an Oracle database. Using OracleApplication Express, you can build a wide variety ofapplications ranging from small simplistic applications to large,complex, and multi-lingual applications. You build anapplication using the Application Builder. Using ApplicationBuilder, you can create two different types of applications:Database applications and Websheet applications. Databaseapplications include both desktop and mobile applications.Websheet applications are similar to WIKIs and suited forcommunity contributions.
ORACLE DATA SHEETApplication Development - It’s all in the BrowserTo build, deploy, and run applications using Oracle ApplicationExpress, you do not need to install any client software. Bysimply using a browser, you log in to your Workspace, navigateto Application Builder and start building beautiful applicationsfor desktops and mobile devices. End users need just a browser,application URL and their user credentials.Utilizing the Declarative FrameworkOracle Application Express uses a declarative framework forweb application development. That is, you specify what to dorather than how to do it. No code is generated or compiled.You interact with a wide variety of built-in wizards and propertysheets to define your application.Short Learning CurveOracle Application Express enables organizations to capitalizeon their existing investment in SQL and PL/SQL skills. Fewprogramming skills are required, and anyone can quickly learn todevelop applications. With Oracle Application Express,applications are built faster, with fewer developers.Using the Advanced Browser-based IDEOracle Application Express includes, Page Designer, arevolutionary browser-based IDE designed to greatly improvedeveloper’s productivity, allowing you to very quickly enhanceand maintain pages within Application Express. The keyfeatures of Page Designer include: Cohesive user experience Better visual representation Intuitive drag and drop Enhanced code editor
ORACLE DATA SHEETFigure 2: Manage application pages using Page DesignerBuilding a better User Interface for your ApplicationsOracle Application Express provides the new Universal Theme,which is an example of a responsive user interface theme.Universal Theme does away with excessive templates andsupports effortless customizations with Template Options,Theme Styles, and Theme Roller. The Universal Themeempowers application developers to build modern, responsive,sophisticated, and accessible applications without requiringexpert knowledge of HTML, CSS, or JavaScript.Mobile Web ApplicationsOracle Application Express incorporates jQuery Mobile toallow developers to rapidly build mobile applications. jQueryMobile is a lightweight framework that enables you to createcompact and minimal web pages that include only a few imagesand CSS files. jQuery Mobile is also aware of and able torespond to mobile device specific events, such as orientationchange and touch events. Mobile applications developed withApplication Express are browser-based applications that runinside the browser on the mobile device.
ORACLE DATA SHEETPackaged ApplicationsOracle Application Express includes a set of businessproductivity applications, easily installed with only a few clicks.These solutions can be readily used as production applicationsto improve business processes and are fully supported byOracle. Packaged applications also include a collection ofsample applications which demonstrate some of the majorfeatures of Oracle Application Express. By default, sampleapplications are fully editable. In contrast, you must unlockproductivity applications before you can edit them. Unlockingan application makes it ineligible for future upgrades or supportby Oracle Support.Flexible Application DeploymentThe definition of an entire application can be easily packagedand exported for deployment and installation into anotherOracle Application Express instance. Once you export anapplication, you can deploy it in a hosted instance or in thecloud for example, in the Oracle Database Cloud Service.Oracle Application Express allows you to seamlessly move yourapplications between environments within your corporatenetwork and public clouds.ConclusionOracle Application Express is Oracle's primary tool fordeveloping Web applications with SQL and PL/SQL. Usingonly a web browser, you can develop and deploy professionalWeb-based applications for desktops and mobile devices.Modern Web application development is made easy due to therich built-in features available in Oracle Application Express.
ORACLE DATA SHEETContact UsFor more information about Oracle Application Express visit http://otn.oracle.com/apex or call 1.800.ORACLE1 to speak to anOracle representative.
Oracle Application Express is a declarative, rapid web application development tool for the Oracle Database. It is a fully supported, no cost option available with all editions of the Oracle Database. Oracle Application Express enables you to create database-centric Web applications that are reliable, scalable, and secure. .
