Overview

What is Oracle Application Express?

Oracle Application Express (Oracle APEX) 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. Using only a web browser, you can develop and deploy professional applications that are both fast and secure.

Whether you are an experienced SQL and PL/SQL developer or a power user used to writing reports, wizards allow you to quickly build Web applications on top of your Oracle database objects. Enhancing and maintaining these applications is done using a declarative framework, all of which increases your productivity.

Oracle Application Express is database-centric and suited to building a vast array of applications. You can start with webifying a spreadsheet to facilitate collaboration or dive right into extremely complex applications with numerous external interfaces such as the Oracle Store. Because Oracle APEX resides within the Oracle Database and can easily integrate with authentication schemes (such as Oracle Access Manager, SSO, LDAP, etc.) you can build secure applications that can scale to meet your largest user communities.

Application Express 4.2.2 is now available - click the Download tab to download the latest version of Oracle Application Express. Application Express 4.2.2 includes numerous bug fixes together with significant improvements and modernizations to the included Packaged Applications. There is also a brand new packaged application, Survey Builder. Each productivity application includes a "What's New" section which itemizes the updates made.

Read the 4.2 Press Release
 

News

• Yahoo Finance, Oracle Application Express 4.2 Now Available (Oct-2012)
• CBR, Oracle introduces Application Express Release 4.2 (Oct-2012)
• MarketWatch, Oracle Application Express 4.2 Now Available (Oct-2012)
• Tech Crunch, New Pricing For Amazon RDS Running Oracle Database To Build, Test and Run Low-Traffic Apps (Sep-2012)

Catalog of all News

Latest Oracle Magazine Articles

Utility Computing in the Cloud (Mar/Apr 2013) Oracle Database Cloud Service lets businesses concentrate on business. Future-Proof (Jul/Aug 2012) Choose the best of today’s tools to build next-generation Oracle Database applications. Extend Your Applications (Jan/Feb 2011) Use plug-ins with Oracle Application Express 4.0 to add custom components. Build Web 2.0 Applications Declarativily (Nov/Dec 2010) Use dynamic actions in Oracle Application Express 4.0 to define interactive client-side behavior. User-Built Applications (Sep/Oct 2010) Oracle Application Express 4.0 Websheets enable end users to integrate, share, and maintain content.

Catalog of all Oracle Magazine Articles

Latest Podcasts and Videos

• Applications Webcast: Ziggo Integrates Oracle APEX into Oracle E-Business Suite - Eelco Peters, IT development and design for Ziggo, shares the benefits Ziggo has seen since the integration of Oracle APEX with the Oracle E-Business Suite, (Sep 2012)
• Applications Webcast: Oracle APEX Integrated with Oracle E-Business Suite at Ziggo - Philip Brand, Software Developer for Ziggo, discusses how the integration of Oracle APEX has brought clarity to applications and helped solve past development problems, (Sep 2010)
• OTN Live Webcast: Justin Kestelyn, OTN Senior Director, interviews David Peake, Oracle Application Express Product Manager, (Sep 2010)
• Database Podcast: Gary Clark, CIO of Liberty Cables, describes how the company leveraged APEX rapidly and easily to develop a Web-based application for handling interactions with Liberty's customers, (June 2010)
• Independent Podcast: Listen to Bill Dwight, Founder and CEO of Famzoo.com talk about famzoo, the ideas behind it, development of the site and hosting it, (Apr 2010)
• Independent Podcast: A talk with David Peake, Product Manager of Oracle Application Express, about key new features of APEX 4.0, (Mar 2010)

Catalog of all Podcasts and Videos

Case Studies

• Seguros Los Andes Optimizes Insurance Policy Management, Makes Patient Admissions 40% More Efficient (December 2012)
• Ziggo Rapidly Creates Applications That Accelerate Communications-Service Orders (December 2012)
• INEOS Group Cuts 80% off Application Design and Build Costs for Managing Hydrocarbon Accounting and Refinery Information (November 2012)
• Constructora Norberto Odebrecht S.A. Expedites Release of Project Funding and Gains Up to $13,000 a Day in Financial Investments (July 2012)
• Purdue University supports Institutional Research with Web-based Data Environment (May 2012)
• Indiana University Supports Researchers, Inspires Innovation and Secures More Research Grants with Web-Based Data Environment (May 2011)

Catalog of all Case Studies

Customer Quotes

"One important goal for us over this year is the need to support multiple platforms and devices including Macs, iPads and iPhones. Application Express 4.2 will allow us to develop an application once and deploy it to all these devices by incorporating ‘Responsive Design’ in the templates that automatically scale from the largest monitors to the iPad in landscape mode. Application Express achieves all this using industry standard responsive grids, mobile libraries and charting tools that work on all the platforms."
-- Sayee Natarajan, Director of Sales Systems, Purdue Pharma

"We at the Brunswick Boat Group are very excited about Application Express 4.2. Our quality control application (QCIS) was written in Application Express to replace a software package costing $60,000 a year. Since delivering our Application Express application we have received rave reviews for its functional richness including the use of image maps. The only complaint is that our users currently have to work off Toughbooks. Application Express 4.2 will enable us to deliver QCIS on iPads which will be far easier and more productive for our users, especially as they can utilize features such as touch and tap."
-- Tony Bowers, Senior Systems Analyst, Brunswick Boat Group

"At Cornerstone Brands we have seven unique Catalog/Internet retail businesses, representing $880 million in sales annually. To manage this business we used Oracle Application Express to quickly build a suite of highly intuitive, rich applications taking up to 10,000 orders a day. We’re especially excited with the enhancements to Dynamic Actions that come with Oracle Application Express 4.1. Oracle Application Express is a tool that is highly proliferated throughout our enterprise, and continues to be the tool of choice as we are presented with new business challenges."
-- Paul Davidson, Director CMS Applications Development, Cornerstone Brands Inc.

"At Northgate Revenues & Benefits, we have used APEX to replace our legacy Oracle Forms system comprising around 1500 Forms. Our user interface has 10,000 end users daily, across 172 clients, who this year sent out over 12 million Council Tax annual bills worth £15billion and will pay out benefits of over £13billion. Our clients now experience, on average, sub second response times across a working day. We are continuing to leverage our investment in Oracle Application Express by delivering citizen facing solutions as well as launching the conversion of our Social Housing application which will replace 3,500 Oracle Forms running at 100 clients worldwide, with a total of 15,000 end users managing circa 3,000,000 properties. Oracle Application Express has helped us to make the move away from Oracle Forms whilst delivering benefits to our clients and our business."
-- Alan Powell, Director of Products and Services, Northgate Public Services

"At PINNACLE Software Corporation, a division of PAETEC Incorporated, we utilize Oracle Application Express to develop our enterprise class Service Lifecycle management software that is used to help IT organizations manage their service support and service delivery business operations. We are eager to begin leveraging several of the new and enhanced features available within Oracle Application Express 4.0 designed to help facilitate larger team development. We are particularly excited about the ability to create dynamic actions and plug-ins to easily extend the functionality of the tool. Additionally, we hope to drive efficiencies within our development organization by leveraging the integrated project management, feedback and bug tracking features built inside the tool."
-- Dennis Vanill, Senior Manager Software Development, PAETEC

Catalog of all Customer Quotes

Books

		Expert Oracle Application Express Security [2013] by Scott Spendolini Protecting APEX Applications from threats and intrusions.
		Hands-On Oracle Application Express Security {Kindle Only} [2013] by RECX Building secure APEX Applications.
		Oracle Application Express for Mobile Web Applications [2013] by Roel Hartman, Christian Rokitta and David Peake Build mobile Web applications with native look-and-feel.
		Beginning Oracle Application Express 4.2 [2013] by Doug Gault, Karen Cannell, Patrick Cimolini, Martin Giffy D'Souza and Tim St. Hilaire Your ticket to easy and robust Web-application development using Oracle's powerful toolset for power-users, programmers, and database administrators.
		Oracle APEX Best Practices [2012] by Alex Nuijten, Iloon Ellen-Wolf and Learco Brizzi Accentuate Oracle APEX development with proven best practices.
		Agile Oracle Application Express [2012] by Patrick Cimolini and Karen Cannell Create a powerful and self-organizing team by applying agile practices to Application Express development. Listen to the Authors Podcast.
		Study Guide for IZO-450: Oracle Application Express 4: Developing Web Applications [2012] by Matthew Morris Preparation for the Oracle Application Express certification exam.
		Create Rapid Web Applications Using Oracle Application Express [2012] by Riaz Ahmed A practical guide for novice and intermediate users to rapidly develop professional web applications
		Expert Oracle Application Express Plugins [2011] by Martin Giffy D'Souza Accelerate your Oracle APEX development with well designed and reusable plug-ins
		Pro Oracle Application Express 4.0 [2011] by Tim Fox, John Scott and Scott Spendolini Make Application Express "dance" with under-the-cover techniques for customizing, securing, localizing and deploying your applications
		Oracle Application Express 4 Recipes [2011] by Edmund Zehoo An example-based approach to learning Oracle's groundbreaking, rapid application development tool
		Expert Oracle Application Express [2011] by Dietmar Aust, Martin Giffy D'Souza, Doug Gault, Dimitri Gielis,Roel Hartman, Michael Hichwa, Sharon Kennedy, Denes Kubicek, Raj Mattamal, Dan McGhan, Francis Mignault, Anton Nielsen and John Scott Thirteen leading lights in Oracle Application Express share their favorite insights from the field

Catalog of all Books