Learn More

Just getting started with Oracle APEX? There is a flash video that positions Oracle Application Express and explains how it can help you improve your business.

Launch the Learn more about Oracle Application Express application that provides a high level overview on the major components within Application Express. Please note that this application is available within every Application Express instance.

Once you are ready to dive in, if you don't have access to a local instance, request a Workspace on our hosted instance, apex.oracle.com. Alternatively, you can download an Oracle VM VirtualBox that we use to support our OTN Developer Days. Using one of these, or your own instance, try out one of our Oracle by Examples (OBEs) and read the Documentation and Tutorials.

Need more? Oracle University offers training on Application Express, SQL and PL/SQL. Started developing and have a question?  Our forum is one of the most active on OTN.

Topics

• Education and How-to Guides
• Certification
• Conversions
• Plug-Ins
• Technical Information and White Papers

Education and How-to Guides

• Oracle University offers Introductory and Advanced courses. For custom courses and on-site options contact Oracle University Global Sales Contacts
• Oracle by Examples - OBEs provide hands-on, step-by-step instructions on how to implement various technology solutions to business problems
  
  
  • Getting Started with Application Express (4.0)
  • Building, Customizing and Using Interactive Reports (4.0)
  • Building Dynamic Actions (4.0)
  • Extending Your Application Using Plug-ins (4.0)
  • Building Charts, Gantts and Maps (4.0)
  • Building a Websheet Application (4.0)
  • All OBEs
• Application Express Documentation
• Advanced Tutorials
• How-Tos for previous releases

Certification

Once you are proficient at Oracle Application Express development you should take the Certified Expert exam. Oracle Certifications are among the most sought after badges of credibility for expertise in the Information Technology marketplace. You can differentiate yourself from your peers or competition and gain valuable job security by earning an Oracle certification.

Oracle Application Express Developer Certified Expert

Conversions

Many organizations struggle with the proliferation of spreadsheets and desktop database applications, such as MS Access.  Departments often develop applications independent of their IT organization, without sufficient safe guards in respect to security, backup and recovery, and data integrity.  Many of these become mission critical yet the underlying technology is incapable of meeting corporate governance requirements.

Additionally, numerous organizations that developed applications in Oracle Forms are now looking to modernize their legacy applications.  Application Express is very adept at converting these applications into modern, Web 2.0 applications that are secure, scalable and reliable.

Spreadsheets  A complete Application Express application can be developed in minutes by simply cutting and pasting a spreadsheet into a wizard.  Instead of users distributing a spreadsheet, they can send a URL to a Application Express application. This prevents data loss, centralizes data storage, backups, etc. and ensures there is a single source of truth - no manual synchronization of data is necessary because everyone is viewing the most current version of the data in real-time. 

MS Access  The Oracle Application Express Migration Workshop assists customers in migrating Microsoft Access applications to Oracle Application Express. It works in harmony with the Oracle SQL Developer Migration Workbench to provide a total solution for your Access Migration requirements. You first use SQL Developer Migration Workbench to migrate your schema definition and data and then use the Oracle Application Express Migration Workshop to migrate your Access forms and reports. The last step is refining your new application taking advantage of all the power and capabilities of Oracle Application Express.

• Migrate your MS Access Applications
• MS Access Migration Tutorial

Oracle Forms  Oracle Application Express provides a forms conversion utility. This enables developers to export Oracle Forms based applications to XML using the standard Forms utility, then import the XML into Oracle Application Express.

Once loaded into a Forms conversion project, a subset of the functionality can be automatically generated as an Oracle Application Express application. For logic that is not automatically converted, Oracle Application Express enables developers to track the manual migration of client-side Forms logic.

• Oracle Application Express for Oracle Forms Developers

See also: Oracle Database Migration Technology

Plug-Ins

Plug-Ins allow for the Application Express framework to be readily extended with custom item types, region types, application processes and Dynamic Actions. View the catalog of Plug-Ins produced by Oracle and link out to plug-in repositories contributed by the community. You can also learn how to build your own plug-ins using this OBE, Extending Your Application Using Plug-ins.

• Catalog of Plug-Ins

Technical Information and White Papers

• Statement of Direction, September 2011
• Check for Updates Privacy Information
• Integrating Oracle Application Express with Oracle Access Manager
• Extending Oracle E-Business Suite Release 12 using Oracle Application Express
• Architecture
• Interactive Reports
• Working with SQL Developer
• PDF Printing
• Web Service Integration
• Upgrading your XE
• Oracle Application Express and Oracle Real Application Clusters, June 2000