United StatesChange Country, Oracle Worldwide Web Sites Communities I am a... I want to...
 

What is Oracle Application Express?

Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle APEX is a fully supported, no cost option of the Oracle database.   Learn more ...


Release 4.1 is now available - click the Download tab to download the latest version of Oracle Application Express.

Read the 4.1 Press Release

Oracle Application Express 4.1

Topics

Related Technologies

Frequently Used Links

New in Release 4.1

The latest release of Oracle Application Express delivers new and refined capabilities. Read about all the new features including:

Recognition

We would like to recognize and thank Recx Ltd. for the use of their ApexSec analysis engine (http://www.recx.co.uk/apexsec), which has been used to improve the security of Oracle Application Express 4.1.

News

View all News

Installing Application Express

Oracle Application Express 4.1 requires:

  • An Oracle Database version 10.2.0.3 or higher
  • Oracle XML DB needs to be installed and configured in the database

 

Whether you're installing Application Express for the very first time or you're upgrading from a previous release of Application Express, the process is identical:

  1. Download the Application Express 4.1 distribution
  2. Unzip the file
  3. Run the Application Express installation script, apexins.sql
  4. Configure your Web server

All details can be found in the Installation Guide

Events

There are many events that are of interest to the Application Express community.

Packaged Applications

Packaged Applications are fully functional applications that you can view, use and customize.

Presentations

The powerpoints below allow you to build your own presentation, pulling just the slides you need. The Project Tasks spreadsheet is useful for demonstrating creation of an application from a spreadsheet together with Interactive Report functionality.

Latest Oracle Magazine Articles

Catalog of all Oracle Magazine Articles

Latest Podcasts and Videos

  • 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)
  • Independant 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)
  • Independant Podcast: A talk with David Peake, Product Manager of Oracle Application Express, about key new features of APEX 4.0, (Mar 2010)
  • Author Podcast: A conversation with John Scott, Oracle ACE and APEX Developer of the Year 2006 and author or Pro Oracle Application Express, (Jan 2010)
  • Database Podcast: Exor Manages Infrastructure Assets with Oracle Database 11g (Dec 2009)
  • Database Podcast: Tennessee Department of Environment and Conservation Saves Money with Oracle Application Express (Nov 2009)
  • Video: Spreadsheets or Simplicity? Short video parody on the problems of using spreadsheets to collate information instead of APEX
  • Video: Why use Oracle Application Express? This short video covers the why and highlights key features of the product

Catalog of all Podcasts and Videos

Books

Oracle APEX 4.0 Cookbook by M. van Zoest and M. van der Plas, 2010 Over 80 recipes to develop and deploy fast, secure, and modern web applications with Oracle Application Express 4.0. [See sample chapter here]

Oracle Application Express 3.2: The Essentials and More by Arie Geller and Matthew Lyon, 2010 Develop native Oracle database-centric web applications quickly and easily with Oracle APEX.

Oracle Application Express for Project Managers: Reference for APEX 3.2 by Adam S. Enos, 2009 Aimed at project managers and technical architects working on their first Oracle Application Express 3.2 project.

Oracle APEX (Oracle Application Express) [French] by Ahcene Bourouis, 2009 This book on Oracle APEX is intended for the business world (developer, project manager and head of information systems) as well as students and faculty.

Oracle APEX und Oracle XE in der Praxis [German] by Dietmar Aust, Jens-Christian Pokolm, Denes Kubicek, 2009 A cookbook with recipes for advanced database developers to use immediately.

Applied Oracle Security 2009 Incorporates chapters on applied security for Oracle APEX written by Tyler Muth.

Oracle Application Express Forms Converter by Douwe Pieter van den Bos, 2009 Convert your Oracle Forms applications to Oracle Application Express successfully.

Beginning Oracle Application Express by Rick Greenwald, 2008 Even if you have limited programming experience, this hands-on guide will get you up and running quickly with Oracle Application Express.

Pro Oracle Application Express by John Scott and Scott Spendolini, 2008 Developing with Application Express? Make it "dance" with under the hood techniques for customizing, securing, localizing, and deploying your applications.

Customer Quotes

"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.

"I am impressed with the Oracle Application Express team’s ability to keep the software updated to the evolving web standards. The team picked jQuery very early over other technologies, identified a good charting engine and put in resources towards mobile application development. We hope to have five to 10 mobile applications in production by Q1 next year, and we are relying on Oracle Application Express 4.1 to help us get there."
-- Sayee Natarajan, Director of Sales Systems, Purdue Pharma

"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

"Oracle Application Express is the heart of our business. Liberty AV uses Oracle Application Express for CRM, inventory management and customer Web applications. Our Oracle Application Express applications are revenue generators. We are very excited about Oracle Application Express 4.0. One of the game-changers for us is the new Dynamic Actions feature. It is expected to reduce our use of JavaScript and allows for faster application development."
-- Gary Clark, CIO, Liberty AV Solutions a subsidiary of Wesco - CSC family of companies

"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

"Oracle Application Express is the primary custom development platform at General Healthcare Group (GHG). Its speed of delivery and ease of use has given GHG an excellent, cost effective, scalable platform to get the right tailored applications delivered when required. We're really looking forward to Oracle Application Express 4.0 where Dynamic Actions and the new reporting capabilities will provide a much richer user experience. Plug-Ins will also help us to technically streamline the way that we create, deliver and re-use custom code, increasing productivity.
-- Marc Yaneza, Technology Director IT, General Healthcare Group

"Application Express operates where work matters - at the department level. Sure it can scale to the enterprise, but I need a tool that I can manage locally, without involving IT, to efficiently collect and report on information that matters to me."
-- Rich Mutell, Director - Strategic Planning & Operations, Amgen

"APEX has allowed us to migrate several disparate Excel and MS Access applications to a consistent, secure, web based environment. The speed and concurrency offered by APEX have been exceptionally valuable."
-- Eric Brandenburg, Senior Applications Architect, Brunswick Corporate IT

"With Oracle Application Express we have been able to streamline business processes by consolidating over 50 MS Access applications. For the first time ever, all users have direct control over their applications and the ability to create ad-hoc reports within minutes using the new common repository. It is estimated the new systems have already saved the department over $900k."
-- Vojin Janjic, Manager Permit Section & David Brewer, DBA Information Systems, Tennessee Department of Environment & Conservation

Case Studies